| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Results of conditional formatting not what desired. How do I corr
My formula produces a dd-mmm-yyyy result which is correct.
Cell L55 formula results a 17-May-2006 Conditional formatting is set to: Formula is: =L55<=TODAY() With background pattern set to red. My problem is that the conditional formatting doesnt produce the results I desire which is that if the date in L55 falls within the month and year that the background will be red. How do I get the conditional formatting to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting producing inconsistant results? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Not Working Consistently | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Threaded Mode
