Hi,

Bob's got your answer.

Tip: When you are going to do multiple rules on the same range use Home,
Conditional Formatting, Manage Rules rather than Conditional Formatting, New
Rule, that way you stay in the conditional formatting area after you click OK
and your next rule begins by just hitting New Rule in the Rules Manager.

Cheers,
Shane Devenshire

"fsfiligoi" wrote:

I'm trying to highlight column A based on the info in column B. For example
I would like to have yellow in column A when it says "maintenance" in column
B and green in column A when it says "free" in column B. How could I do this?

A B
Time Slot Time Slot Usage
12:00 AM Maintenance
12:05 AM Free
12:10 AM Automated Report
12:15 AM Maintenance
12:20 AM Maintenance