Odd white out results

[GerryK]

Hi,
I'd like to "white out" a block of text in H10:I17 based
on the time of day from A2 =NOW()
My conditional formatting of the block of cells is white
based on the "formula is": =A2>8:30.
My problem is that H10, H11,I10 and I16 go white but not
the other cells in the range.

Am I formatting wrong?
TIA

 

[Keri]

Try $A$2>8:30 -- that may work

 

[Frank Kabel]

Hi
as NOW returns a date/time value use the following formula
=MOD($A$2,1)>=TIME(8,30,0)

 

[GerryK]

Thank you Frank, that worked!
If I want to do the same based on a date and a time in the
future, what modification to the format formula could I
use for as example, next week at 8:30 a.m.?
TIA

 

[Frank Kabel]

Hi
try
=$A$2>=TODAY()+7+TIME(8,30,0)

-----Original Message-----
Thank you Frank, that worked!
If I want to do the same based on a date and a time in the
future, what modification to the format formula could I
use for as example, next week at 8:30 a.m.?
TIA

.