If/Then and conditional formatting question

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

Guest

Hi,

I have a tracking spreadsheet that has a formula to compute a due date in
column G. The project managers manually enter their completion date in column
H

I need a way to do this: If date in column G is greater than or equal to
today's date AND column H is empty then make date in Column G red.

Any suggestions?

Thanks
Max
 
Format > Conditional Format > Formula is >

=AND(G5>=TODAY(),H5="")

Set the format you require.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Wonderful! Thanks Sandy

Cheers

Sandy Mann said:
Format > Conditional Format > Formula is >

=AND(G5>=TODAY(),H5="")

Set the format you require.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
Click to expand...
 
You're very welcome, glad that you got it to work.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top