Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Conditional Formatting
|
|
|
The UK's most regular 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. |
financial excel course london - Conditional Formatting
Resolved · Low Priority · Version Standard
Reply Mon 17 Sep 2007, 14:36Delegate Katie said...
Katie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Conditional Formatting
when i have entered date into my table, and i wish to use the "traffic light" system... if some of my boxes are blank but i wish to have two seperate rules for different blank boxes... how can i format some to Amber and some to Red? without entering any data. i would like an automatic response everytime i access the worksheet. Many thanks.
For upcoming training course dates see: Pricing & availability
RE: Conditional Formatting
Hi Katie
Thanks for your question.
You will need to have something different in the cells you wish to mark amber to the cells you wish to mark red, as Excel can only apply one rule to one formatting rule.
I hope this helps.
Amanda
|