Range Change Colour
Solved/Closed
Related:
- Range Change Colour
- Crimping colour code - Guide
- Change computer name cmd - Guide
- Change lg tv name - Guide
- T-mobile change number - Guide
- How to change language in kmplayer - Guide
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
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
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