Formula to highlight a cell

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

What formula can I put A1 so as if there is no date in A2 it will change to
Red Highlight in A1

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Hi Bob
- highlight cell A1
- goto 'Format - Conditional Format'
- choose Formula and enter =A2=""
- choose your format
This will highlight cell A1 if cell A2 is blank

In addition - if you want to check for correct dates in A2 - goto
'Data - Validation' and choose date

HTH
Frank
 
Back
Top