Range Change Colour

Solved/Closed
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

Andy

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

=$A$1="lose"

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
=$A1="lose"
and close color red
0
Thank you,
0