Change cell colour

R

Ron Sivers

Can anyone advise on changing cell colour when cell criteria has bee
met i.e when date entered has been exceeded by 14 days the cell change
to another predetermined colou
 
D

Debra Dalgleish

You can use Conditional Formatting, with the TODAY function:

Select the cell that you want to colour (A2 in this example)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the active cell
=A2+14<TODAY()
Click the Format button
On the Patterns tab, select a colour for highlighting
Click OK, click OK

There are other examples of conditional formatting here:

http://www.contextures.com/xlCondFormat03.html
 
Top