Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching specifc dates using Conditonal format
Hi Guys, hopefully someone might be able to help me.
My small problem is this With a an examination date in say, Cell A1, I would like B1 to Flash up "green" when the date in B1 is within 1 Month of the date within A1 and "Red" when the date is past the date in A1. Hope that makes sense. Cheers i advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Format Problem | Excel Discussion (Misc queries) | |||
Pivot Table Conditonal Format of the Grand Total | Excel Worksheet Functions | |||
Conditional Format matching Dates,calendar | Excel Discussion (Misc queries) | |||
Conditonal Format Formula | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) |