View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony wong tony wong is offline
external usenet poster
 
Posts: 14
Default Conditional format - max

i wish to highlight the cell at largest value in some cells (A1, A3, A5...)
in A column

i know how to do it if they are all the cells in A column
=A1=max($a:$a)

how can i do selectively if they are just A1, A3, A5...?

Secondly, the value of A1, A3, A5... are less than 10, other values in the
column are larger than 10.

Can i make use "countif" to do above?

Thanks a lot.

tony