View Single Post
  #1  
Old April 22nd, 2009, 04:57 PM posted to microsoft.public.excel.worksheet.functions
CE
external usenet poster
 
Posts: 19
Default Conditional Formatting Using Min/Max

Regarding Excel 2003, I want to indicate the min value in a non-contiguous
range of cells. The data are located in cells G8, K8, O8, S8, W8, AA8 and
each cell contains a formula. So far I've tried the following formulas but
without success.
1) =MIN(G8,K8,O8,S8,W8,AA8)
2) =G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8)
3) =G8=MIN($G$8,$K$8,$O$8,$S$8,$W$8,$AA$8)

Please help!