Prev: Save spreadsheet using cell values as filename
Next: CHARTS
From: Josh Doten on 23 Mar 2010 10:04
I am trying to do some conditional formatting which requires me to compare
two "time" values".

Basically what I'm doing is changing the text color if the value of a cell,
which is formatted as a time of day, if that time is greater than 9:00 PM.

In the conditional format I tried "Use a Formula to determine which cells to
Format" with the formula "=$B3>9:00 PM" and several varients of the same
general idea. 90% of them returned errors, the other 10% made everything
true... even if it wasn't. The idea is that if B3's value were after 9:00 PM
the text would turn red.

Any idea what I'm doing wrong?
From: Luke M on 23 Mar 2010 10:09
With that quote placement, you made the logic check a giant text string.
Try:
=$B3>TIME(21,0,0)

--
Best Regards,

Luke M
"Josh Doten" <JoshDoten(a)discussions.microsoft.com> wrote in message
news:4B94A380-ECF6-4E6F-BE8B-50254DC96C71(a)microsoft.com...
>I am trying to do some conditional formatting which requires me to compare
> two "time" values".
>
> Basically what I'm doing is changing the text color if the value of a
> cell,
> which is formatted as a time of day, if that time is greater than 9:00 PM.
>
> In the conditional format I tried "Use a Formula to determine which cells
> to
> Format" with the formula "=$B3>9:00 PM" and several varients of the same
> general idea. 90% of them returned errors, the other 10% made everything
> true... even if it wasn't. The idea is that if B3's value were after 9:00
> PM
> the text would turn red.
>
> Any idea what I'm doing wrong?


 | 
Pages: 1
Prev: Save spreadsheet using cell values as filename
Next: CHARTS