View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alfaista alfaista is offline
external usenet poster
 
Posts: 6
Default 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!!