Formula to highlight a cell

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
..
..
..
..
 
F

Frank Kabel

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
 
Top