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

  • Thread starter Thread starter alfaista
  • Start date Start date
A

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!!
 
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
 
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!!
 
Back
Top