←
→
oldbloke: (Default)
Add MemoryShare This Entry

Brrrrrr

posted by [personal profile] oldbloke at 12:37pm on 14/10/2008
Dank and dismal here today, and cold - eventually I gave in and hit the +1hr button on the heating. Nothing - the thermostat disagrees with my assessment of the situation. Bloody machines!
←
→
There are 12 comments on this entry. (Reply.)
 

(no subject)

posted by [identity profile] k425.livejournal.com at 11:42am on 14/10/2008
If you're wearing a jumper and you've done some strenuous housework and you've had a hot meal and hot drink and you're still cold, turn the thermostat up and try again.
[link] [reply]
hooloovoo_42: (Default)

(no subject)

posted by [personal profile] hooloovoo_42 at 12:25pm on 14/10/2008
Can you sort out my conditional formatting? I'm trying for "If the date in this cell is more than a month ago AND if the next cell is not "Y" AND if the next but one cell is blank, colour this cell red". I can manage to make it go green for reviews done and purple for reviews to do this month, but not red for reviews missed!
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] oldbloke.livejournal.com at 12:28pm on 14/10/2008
I'll have a look when I get back from the shops... but there might be too many conditions in the list for Excel, I think the limit is quite low.
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] k425.livejournal.com at 12:29pm on 14/10/2008
Haha. No, but I know a man who can...
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] oldbloke.livejournal.com at 01:50pm on 14/10/2008
I don't think you can do it with conditional formatting
I suggest your best bet is an extra FLAG!!! column with a nice formula in it that gives you simple values you can use for the conditional formatting to work on.
So if the flag column was A, the review due date in B, has it been done in C, scheduled for in D, you have something in A like:
=IF($C2="Y", "DONE", IF($D2<>"", "SCHEDULED", IF($A2<(TODAY()-31), "OVERDUE", "TO DO"))))

Then you can conditional format from that.
I used row 2 as I guess you'll have headers in row1...
[link] [parent] [reply]
hooloovoo_42: (Default)

(no subject)

posted by [personal profile] hooloovoo_42 at 02:57pm on 14/10/2008
I sorted it, ta. Used =IF(AND(I19<>"",I19<$E$1, J19<>" ", K19=""), TRUE)

it just took a bit of tweaking, especially to ignore the blank rows.
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] oldbloke.livejournal.com at 03:05pm on 14/10/2008
THAT DOESN'T DO WHAT YOU ASKED FOR!!!

bloody users...
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] anged.livejournal.com at 01:59pm on 14/10/2008
Down the valley I'm under a fleecy blanket and have a hot water bottle and I'm still cold.

May I light a fire?

[link] [parent] [reply]
 

(no subject)

posted by [identity profile] k425.livejournal.com at 02:09pm on 14/10/2008
Yes, you've been poorly. And regardless of being poorly if you've got a fleecy blanket and a HWB and you're still cold you need the heating on!
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] bellinghman.livejournal.com at 11:43am on 14/10/2008
Go out for a half hour walk. When you get back in, it'll feel much warmer, 'cos your own thermostat will have reset itself.
[link] [reply]
 

(no subject)

posted by [identity profile] oldbloke.livejournal.com at 02:41pm on 14/10/2008
It was warmer outside!!!
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] bellinghman.livejournal.com at 02:43pm on 14/10/2008
That's Not Right™
[link] [parent] [reply]

May

SunMonTueWedThuFriSat
        1
 
 2
 
 3
 
4
 
 5
 
 6
 
 7
 
 8
 
 9
 
 10
 
11
 
 12
 
 13
 
 14
 
 15
 
 16
 
 17
 
18
 
 19
 
 20
 
 21
 
 22
 
 23
 
 24
 
25
 
 26
 
 27
 
 28
 
 29
1
 30
 
 31