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