If/Then and conditional formatting question

[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

 

[Sandy Mann]

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

 

[Guest]

Wonderful! Thanks Sandy

Cheers

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

 

[Sandy Mann]

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