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