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

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

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

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

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

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

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

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

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

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