| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on Current or previous Quarter entries
I want to format cell A1 to turn red if the date in cell A1 is not within the
current or previous quarter date specified in cell B2 with: =DATE(YEAR(TODAY()),INDEX({3;6;9;12},INT((MONTH(TO DAY())+2)/3))+1,0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting to group rows with repeating entries | Excel Discussion (Misc queries) | |||
| Formatting cell to show current Quarter | Excel Worksheet Functions | |||
| Conditional formatting: colored bar with pointer on current status | Excel Discussion (Misc queries) | |||
| Calculate % variance on previous quarters. Quarter %, etc. pivot | Excel Discussion (Misc queries) | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Threaded Mode
