Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Conditional format numbers | Excel Worksheet Functions | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Conditional format of minimum number | Excel Worksheet Functions | |||
Conditional Format Question | Excel Worksheet Functions |