Test dates and format

[cbrink]

Hi,

I've attached an example.
I need to test dates in Col G and change the color in Col G depending on late or still in the future.
However, if Col J is populated, Col G should be 'green', being finished or done.

Any help will be appreciated.

[vlady]

maybe this could help you change the fill color.
CF on dates

example (9).xlsx

[cbrink]

Hi vlady

Thank you for this, it is already of great help!
There should actually be 2 conditions:
1. If the value in Col G is behind today(), it (date in cell in Col G) must be red, but if Col J has a date, it must be green.
2. If the value in Col G is ahead of today(), it must be green.

Is this possible?

[vlady]

=$G13<today() format to red

=or($G13>today(),$J13<>"") - format to green

delete the other condition i put--use "formula is"
tel me if it works for you.

thanks.

[cbrink]

Hi vlady,

Seems not to be working, see attached.

[vlady]

here:

cbrinkexample.xlsx

[cbrink]

Thanks vlady, resolved!

[vlady]

Your very much welcome cbrink.

You can mark this thread "solved" then.

Go to your post #1 - click edit - then follow the steps on my signature below.

Thanks for the rep.