Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
I have cells with the following information in them and need to apply CF:
"1+" - the cell need to be Green "1" - the cell need to be Green "1-" - the cell need to be Green "2+" - the cell need to be Green "2" - the cell need to be Green "2-" - the cell need to be Amber "3+" - the cell need to be Red "3" - the cell need to be Red "3-" - the cell need to be Red "4" - the cell need to be Red Can it be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Set your thre CF conditions as beow:
Green =OR(A1="1+",A1="1",A1="1-",A1="2+",A1="2") Amber =A1="2-" Red =OR(A1="3+",A1="3",A1="3-",A1="4") HTH "Teri" wrote: I have cells with the following information in them and need to apply CF: "1+" - the cell need to be Green "1" - the cell need to be Green "1-" - the cell need to be Green "2+" - the cell need to be Green "2" - the cell need to be Green "2-" - the cell need to be Amber "3+" - the cell need to be Red "3" - the cell need to be Red "3-" - the cell need to be Red "4" - the cell need to be Red Can it be done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
On Jun 14, 12:43 pm, Teri wrote:
I have cells with the following information in them and need to apply CF: "1+" - the cell need to be Green "1" - the cell need to be Green "1-" - the cell need to be Green "2+" - the cell need to be Green "2" - the cell need to be Green "2-" - the cell need to be Amber "3+" - the cell need to be Red "3" - the cell need to be Red "3-" - the cell need to be Red "4" - the cell need to be Red Can it be done? I don't know if that can be done but there are a lot of ways to get around problems in Excel. You could try to insert a dummy column and for every value that you want it to be formatted as green give it a 0, for Amber give it a 1 and for Red a 2. Then you can do your conditional formating based on that dummy column. If it works hide the dummy column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
??conditional formatting?? | Excel Worksheet Functions | |||
conditional formatting ? | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |