Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to format various columns of data so that the highest value in the
column shows as bold (ie; cells A1:A300 - A57 is bold as it has the highest value). I am trying to do this in conditional formatting by selecting the range (ie; A1:A300) so that A1 is the active cell and then: Formula Is =MAX(A1:A300) But all of the cells are shown as highlighted! What am I doing wrong? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting Max and Min | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |