conditionally format cell in a range, based on value in other rang

[alfaista]

okay, i didn't think this was that hard, but i seem to be stuck.

i have a range of values, say AH2 thru AH63, and i want to compare these
cell values with the same cell values in range AF2 thru AF63.
if they are not equal, i would like them highlighted.

so, if AH2<> to AF2, then highlight it.

can i do this with a range or do i have to have a format on each and every
cell!?!?

thanks in advance!!

 

[Tom Hutchins]

Apply the conditional formatting to the first cell, then use Format Painter
to copy it to the rest of the range. So, in AH2, set a 'Formula Is" condition
of

=(AH2=AF2)

and select the formatting to be applied when the condition is true. Then use
Format Painter to copy the same conditional formatting to AH3-AH63.

Hope this helps,

Hutch

 

[Mark]

You can use "conditional formatting" under the "Format" menu item.

Mark

 

[alfaista]

thanks, this will work. a bit of a pain to do that to each cell. if i try
to use the format painter on the range of cells, again, it doesn't work.
sure would be nice to have a way to do this with ranges!!!

thanks!!

 

[alfaista]

no, not so much. at least not with a range that i've been able to figure out.