Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format VB Code for Begins With | Excel Discussion (Misc queries) | |||
Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
date format in code | Excel Discussion (Misc queries) | |||
Code for Conditional format | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |