Range Change Colour

Andy - May 5, 2010 at 05:43 AM
 Andy - May 5, 2010 at 08:14 AM
Please help.

If I have a range of Data in cells say A1 to E1 and I wish to change all to red when I enter the word "lose" in A1 only what do I need to do this please.

Thank you


2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 5, 2010 at 06:14 AM
You can do it by using conditional format

Select range A1:E1

goto conditional format

type in formula


and then click the format button there and choose red color

by the way, if you plan to do same for A2:E2 ....

Then select columns A:E and in conditional format type
and close color red
Thank you,