| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I conditional format for data that's repeated
I would like to highlight data using Conditional Formatting from a list of
numbers but only want to highlight the 2 smallest numbers. E.g. Data list = 6,7,8,1,9,2,4,2 The result should highlight the number 1 BUT ONLY THE FIRST 2 - I don't want both 2s highlighted. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format of data tables in charts | Charts and Charting in Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| make a conditional format the default | Excel Discussion (Misc queries) | |||
| Conditional format | Excel Discussion (Misc queries) | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Threaded Mode
