Hi Guys,

Hope some one out they can help me, as I am loosing my mind trying to work this out!!!!

I am trying to do a conditional formatting (fill with colour ) on a blank cell based on if data is correct from on cell in a different cell.

this is for staff Rota's

EG:

Cell B2 = Colour Fill if the data in Cell B1 match's Cell A2

Cell B 1:09.00-10.00 Cell C1 10.00-11.00

Cell A 2 09.00-18.00


Please can any one help?

or know of a some way to do a formula that can help?

I am begging, Please or my brain will explode with rage.