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

"alfaista" wrote:

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