Equal Cells


T

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
 
Ad

Advertisements

T

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Equality 5
Cells equal a number 3
Sum equal cells 2
Painting equal cells 2
equals merged cells 2
count if the two cells are equal 3
Cell CODE equals #VALUE! 3
Selecting cells equals to a value 3

Top