Solved: change the font color automatically

[Sathisc]

Hi,

I update a spreadsheet everyday which contains lots of data
In a colum there will be an update "Smart" or any other word without smart.
I need to highlight the entire rows color to red which has smart in a filed.

I have attached a sample spreadsheet.

Thanks,
Sathish

[mdmackillop]

Use conditional formatting

[Sathisc]

THANK YOU SO MUCH IT WORKS:rotlaugh: