Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Formula Is =B1 <= TODAY()
-- Regards, Peo Sjoblom "Kevin" wrote in message ... Hey thanks, Now how do I get it to stay red if it past todays date? "JE McGimpsey" wrote: One way: Select column B, with B1 the active cell. Choose Format/Conditional Formatting and set the dropdowns and inputboxes to: CF1: Formula Is =B1 = TODAY() Format1: <patterns/<red CF2: Formula is =B1 = TODAY() + 3 Format2: <patterns/<yellow In article , Kevin wrote: I would like to make a conditional format for column B, I would like the cell to turn red if it is today?Ts date and yellow if it is 3 days from today. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |