Code to conditional format all black after date specified in code?

[wx4usa]

I have a date in cell A100 sheet 1

Can anyone provide a code that will conditionally format an entire
sheet (sheet2) to black fill and font if now() is greater than date in
cell A1?

Or perhaps change sheet 2 to Very Hidden.

 

[JE McGimpsey]

One way:

Select all cells in sheet2. Choose Format/Conditional Formatting:

CF1: = $A$1 < NOW()
Format1: <pattern>/<black>, <font>/<black>

Note that this will not prevent one from seeing the formula/value in the
formula bar. The user will also be able to, say, on another sheet, enter

A1: =Sheet2!A1

and copy down and across, revealing the values.

 

[wx4usa]

One way:

Select all cells in sheet2. Choose Format/Conditional Formatting:

CF1:     = $A$1 < NOW()
Format1: <pattern>/<black>, <font>/<black>

Note that this will not prevent one from seeing the formula/value in the
formula bar. The user will also be able to, say, on another sheet, enter

A1:      =Sheet2!A1

and copy down and across, revealing the values.

Thanks, that worked!