Equal Cells

[ThomP]

Not sure if this will work. I have a cell with fields #'s (ie. 4A, 4B,
4C....); in the next colum is time (ie 9 am, 10 am, 11 am .....). How can i
get the cells to highlight if I have 2 saying 4A - 9 am. Could not get
conditional formatting to do it. Using Office 2003. Hope this makes sense.

Thanks

 

[ThomP]

Thanks for the reply, I should try to explain better. A2 is 4A, B2 is 9 am,
if anywhere in A3 thuru A100, B3 thru B100, the combination of 4A 9am shows
up I would like it to highlight.

Hope that is explained better

 

[ThomP]

Got it thank you,