Conditional Formatting
I am trying to change the colour of the cell according to the value,
specifically a date value. If a date in the cell is later than the present date I would like the cell to turn red. Can anyone help. |
This worked for me.
Format | Conditional Formatting Cell Value is Greater than =Today() tj "confusedjoel" wrote: I am trying to change the colour of the cell according to the value, specifically a date value. If a date in the cell is later than the present date I would like the cell to turn red. Can anyone help. |
Put todays date somewhere on the sheet. For example, make the D1 formula
=TODAY(). Select the cell or cells you want to format. Use Format|Conditional Formating and made Condition 1: Cell value greater than =$D$1 and then click on the Format button and select the font and pattern (background) colors. "confusedjoel" wrote: I am trying to change the colour of the cell according to the value, specifically a date value. If a date in the cell is later than the present date I would like the cell to turn red. Can anyone help. |
All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com