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

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

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.
 
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.
 
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.
Click to expand...

Thanks, that worked!
 
Back
Top