ExcelBanter - Can I program Excel cells to change colour at a set date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I program Excel cells to change colour at a set date? (https://www.excelbanter.com/excel-discussion-misc-queries/44379-can-i-program-excel-cells-change-colour-set-date.html)

sunflowermurray

Can I program Excel cells to change colour at a set date?

I want certain cells to change from yellow to green when a date contained
within those cells is reached. Excel version 2003

Jerry W. Lewis

Use a conditional format. For instane you might format as yellow, then
set a conditional format based on the formula
=TODAY()=datecell
to apply the green color.

Jerry

sunflowermurray wrote:

I want certain cells to change from yellow to green when a date contained
within those cells is reached. Excel version 2003

All times are GMT +1. The time now is 01:31 PM.