Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format
I would like to use the conditional format function to change the
background color of a cell. My spreadsheet contains the following columns: A)Today's Date B) Date of Last Visit C) Date of Next Visit I want to set up an alert system in column C - highlight the cell in column C yellow if it is two months or less prior to today's date - highlight the cell in column C red if it is past today's date (over-due) I have gotten confused on setting up the right equation using the dates. Thanks in advance for assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |