Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
I have several columns that I would like to apply Conditional Formating to
but exclude cells that have $0.00 in them. I would like to use a 3-color scale from lowest being green, mid being yellow and highest being red. and be able to copy it down the columns after it is created. Example: A B C D E F G H I J K L M N O P 7 Item1 X X 1.25 X X 0.00 X X 0.00 X X 1.00 X X 1.38 8 Item2 X X 1.25 X X 0.00 X X 0.00 X X 1.08 X X 1.50 9 Item3 X X 1.30 X X 0.00 X X 0.00 X X 1.20 X X 1.33 10 Item4 X X 1.85 X X 0.00 X X 0.00 X X 1.20 X X 1.50 Etc... I would like the conditional formating to apply per row and apply the color as long as it doesn't have a 0.00 in it and rank it from lowest to highest for cells D7,G7,J7,M7, and P7. Then I would like to copy that setup down the columns to work the same way. I have about 100 rows as it stands now with information and formulas already put together and I do not want to mess that up. Can anyone help? Thanks, Scott A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
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) | |||
copy conditional format to regular format | Setting up and Configuration of Excel |