Thank you!

"Bob Umlas, Excel MVP" wrote:

Click col A, use conditional formatting, select New rule, select "use a
formula to determine which cells to format, then enter:
=b1="Maintenance" (assuming A1 is active), then click Format & pick the
color you want; then do it all again (from New Rule), enter =b1="Free", click
Format, etc.
HTH

"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