| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in excel conditional formatting find the greatest value in 4rows
in excel conditional formatting i want to find the greatest value in a column
and change its colour |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in excel conditional formatting find the greatest value in 4rows
Hi!
Suppose the numbers are in the range A1:D5 Select the range A1:D5 Goto FormatConditional Formatting Formula is: =A1=MAX($A$1:$D$5) Click the Format button Select the style(s) you want OK out Biff "prac g" wrote in message ... in excel conditional formatting i want to find the greatest value in a column and change its colour |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| excel conditional formatting default | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Excel Conditional Formatting Question | New Users to Excel | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Linear Mode
