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
|