View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SunshineinFt.Myers SunshineinFt.Myers is offline
external usenet poster
 
Posts: 1
Default Applying Conditional Formatting to a Max number in range

I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I am not
sure how to specify that I want the number 10 which is the max number in the
range to turn green or any color. I type =(max) A1:A3. Choose my color and
apply but it never changes. Help this is for work!