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
