Changing Text color when a date has past

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I'm writing a simple spreadsheet tracking events due once
per year. I would like to simply change the text of a
cell to RED when the date in that cell has past. Can
anyone help me? Thanks.
 
Use conditional formatting with a condition of Formula Is and a formula of
=AND(A1<>"",A1<TODAY())

where A1 should be replaced by the first of your target cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
one way:
- select this cell (e.g. cell 1)
- goto 'Format - Conditional Format' and enter the formula
=B1<TODAY()
- choose a format
 
Back
Top