Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell colour format according to date
If a cell value is equal to today I want the colour to change to red. I have
entered =TODAY as a conditional formatting value but the cell colour does not change. The cell has been formatted as ddd dd mmm. Any ideas please. Thanks in advance for any help John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell colour format according to date
Hi John
Try the below 1. Select the cell/Range (say A1:A10). Please note that the cell reference A1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =A1=TODAY() 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. -- Jacob (MVP - Excel) "John Web" wrote: If a cell value is equal to today I want the colour to change to red. I have entered =TODAY as a conditional formatting value but the cell colour does not change. The cell has been formatted as ddd dd mmm. Any ideas please. Thanks in advance for any help John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I Sum by Cell Colour or Format? | Excel Discussion (Misc queries) | |||
Format Cell Colour | Excel Worksheet Functions | |||
Format Cell Colour | Excel Worksheet Functions | |||
Format Cell Colour | Excel Worksheet Functions | |||
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown | Excel Programming |