Colour changeing cells

Is there a way to change a colour of a cell by entering text example I want to say if a1=tl then change cells a1 b1 and c1 to red

select Cell A1 then follow below step:

Go to Home>Conditional Formatting>New Rule>choose "use a formula to determine which cell to format">put formula =A1="TL">Then go to format>click on Fill Tab>select Red Colour>click OK

simirarly select B1 & C1 cell then follow above step.


pl find attached book.xlsx

Thank you very much