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

 

[NBVC]

Are you meaning'


Formula Is >> =AND(A2="4A",B2="9 am")

or something like that where A2 and B2 are top most cells in th
selection to highlight

 

[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

 

[NBVC]

Select A3:B100 and invoke Conditional Formatting through Format menu.

Select Formula is from 1st drop down and enter formula:

=AND(A3=$A$2,B3=$B$2)

Click Format and choose your colour schem

 

[ThomP]

Got it thank you,