View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vmohan1978 vmohan1978 is offline
external usenet poster
 
Posts: 38
Default Conditional Formatting

Dear All,
I am preparing a compartive statement i want to highlight the max and min a
group of cells.
quote-1 quote-2 quote-3
100 150 200

like this upto quote-6
I want to highlight the number max of 6 as red and min of 6 as yellow.

Please do the needful .