I tried that but I'm basically telling excel to highlight column A in green
when it says "free" in column A and I want to highlight column A when it says
"free" in column B.

"Eduardo" wrote:

Hi,
Highlight column A Do, home, conditional formating,Highligth cells rules,
format cells that are equal to and right Maintenance and choose the color
desired, repeat the process for Free changing the color
This will do the trick

"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