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? |
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? |
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 |
All times are GMT +1. The time now is 09:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com