Thread: Highlight specific cells in a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny Johnny is offline
external usenet poster
  
Posts: 126
Default Highlight specific cells in a row
Am using =SUM(LARGE(B6:BA6,{1,2,3,4,5,6,7,8,9,10,11,12})) to identify and
total the twelve highest numbers in a row of 52 cells.
The values in the cells can change.
I am trying to work out how to highlight the cells with the twelve highest
numbers, not forgetting that the twelve highest numbers can change.
Can anyone help?
Reply With QuoteReply With Quote