conditional formatting of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can cells be formatted conditionally to show when the current date is
exceeded? Example- If the value of cell A1 ( 08/06/07) is exceeded by the
current date of the system, then the cell will either change color, flash, or
in some way show up to be recognized?
 
Select the cell you want this to apply to (assume it is A1), then
Format | Conditional Formatting and in the pop-up panel you should
first select Formula Is rather than Cell Contents from the drop-down.
In the next panel enter the following:

=A1<TODAY()

Then click on the Format button and then the Patterns tab (for
background colour) and select the colour you want to use. Click OK
twice to get out of this and test it by putting different dates in A1.
You can use the Format Painter to copy this format to other cells.

Hope this helps.

Pete
 
I followed the directions and upon entering a date before today's date,
nothing happened to the cell. Help?
 
Nothing will occur if the date in A1 does not exceed today's date.

Try =A1>TODAY()


Gord Dibben MS Excel MVP
 
Back
Top