Good afternoon everybody and Happy New Year!



My name is Simone.

I wonder if you can help me with a task I seem to don't be able to achieve.

I have a file excel that I use when I test the functionality of meeting rooms that other companies install for us. Unfortunately this process of installing has always some snags. My work is to highlight this snags and make sure that they are fixed before signing the rooms out.

On this file excel I have several rows where I write down the snags and in these rows I have two dates: the one when the snags have been raised and the one when the snags have been rectified.

Now what I would like to do is this: in order to go quicker in checking what snags have been rectified and what haven't, I would like to use the conditional formatting that helps me highlighting the whole row in red when the date of the snag being raised is filled while the rectification date isn't not, and to change the background colour of the row to green when the date of rectification of the snag is present and it's the same or it's later than the date of the snag being raised.

I hope this makes sense.

Thank you very much for your help.

Regards,

Simone

Hi
could you please post a sample sheet ( no pics please) - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here's a start. I made two examples. The one on the left uses the rules you stated literally. In such cases, if someone enters a rectification date that is earlier than the date the snag was logged, the row is not highlighted at all.

The one on the right highlights such rows as complete but also highlights that there is a logical error in the dates.

Let me know if this helps or if you need help understanding the conditional formatting equations.

Attached Files

RoomCheck.xlsx (10.7 KB, 16 views)

Thank you very much for the answers, Pecoflyer and gebobs.
I used gebobs sample file to understand the logic behind the conditional formatting.

Take care,

Simone