| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format, day of month
I have a column filled with sequential dates. Cell A41 will always be the
30th day of a month, cell A42 will be EITHER the 31st day of that month OR the first day of the next month. IF A42 is the first day of a month I would like to format it with white text. I understand how to use conditional formatting (change text color) but what should the condition state? I tried; "If the cell value is less than =DAY(31)" but that's not right. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
| conditional format for if month(today) = xxx | Excel Worksheet Functions | |||
| Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
Threaded Mode
