conditional formatting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting

Conditional Formatting

resolvedResolved · 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

RE: Conditional Formatting

Yes thats worked!

Thanks again amanda! very helpful.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Removing the Ribbon from view in Excel 2010

At 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.

View all Excel hints and tips


Server loaded in 0.08 secs.