View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SunshineinFt.Myers[_2_] SunshineinFt.Myers[_2_] is offline
external usenet poster
 
Posts: 14
Default Conditional formatting Max to a entire row A1:D1 with E1 being Ma

Hi again. Example: Max numbers are in ending column say E1, E2, ect... but I
do have numbers in all other cells that are higher numbers then what is in
cell E1 but I do not want to find their max or min value: A1, B1, A2, B2,
going down but do not want to count them. Only want to highlight the entire
row that has the ending Max and ending low with the colors green and red
being low.