98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting
Conditional Formatting
Resolved · High Priority · Version 2003
Gareth has attended:
Excel VBA Intro Intermediate course
Excel Intermediate course
Excel Advanced course
Conditional Formatting
Hey
I need to add a criteria to one of my conditional formats. At the moment I have used up all 3 conditions to show different cell colors.
Review = Red
Send = Yellow
Dispose = Green
What I would like to do is add a second criteria to flash up green. At the moment my conditional formatting shows
cell vale equal to " Dispose" is green, can I add a second text "Dispose - Negative" to the third line of conditioning. I need it to show up in green so i dont need more than 3 conditions per se just add a criteria to my third condition. Can this be done?
Any help much appreciated.
Gareth.
RE: Conditional Formatting
Hello Gareth
Thank you for your question.
Can I just clarify, what you would like to do is alter your third condition so that if you have a cell that displays either 'Dispose' or 'Dispose - Negative', you would like that cell to be shaded in green?
Kind regards
Amanda
RE: Conditional Formatting
Yes Amanda that's exactly it!
RE: Conditional Formatting
Hi Gareth,
OK, so I found the following suggestion, this will only work however if the cell range you are applying the conditional formatting to doesn't contain any other cell entries that start with the letter 'D'.
Set the third condition to:
Formula Is: =LEFT(cell ref)="d"
Make sure the (cell ref) is relative, e.g. A1 rather than $A$1
Kind regards
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Removing the Ribbon from view in Excel 2010At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view. |