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

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

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

Mark

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

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

"Tom Hutchins" wrote:

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

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

"Mark" wrote:

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

Mark

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