| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
I'm looking to hi-lit a cell when the number(s) each 5 or increments of 5.
E.G. 4.9 5.1<--- hi-lit 8.9 10.1 11.1 13.5 15.6<--- hi-lit 19.7 20.25 22.3 26.5<--- hi-lit |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format
Aren't you missing 10.1 and 20.25?
Do you want to highlight everytime there is a 5 in the number? Please explain again. "pgarcia" wrote: I'm looking to hi-lit a cell when the number(s) each 5 or increments of 5. E.G. 4.9 5.1<--- hi-lit 8.9 10.1 11.1 13.5 15.6<--- hi-lit 19.7 20.25 22.3 26.5<--- hi-lit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
