Odd white out results

  • Thread starter Thread starter GerryK
  • Start date Start date
G

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
 
Hi
as NOW returns a date/time value use the following formula
=MOD($A$2,1)>=TIME(8,30,0)
 
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
 
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

.
Click to expand...
 
Back
Top