Change the text colour based on the value in the cell
Closed
aravind
-
Jul 15, 2014 at 06:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 15, 2014 at 10:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 15, 2014 at 10:55 AM
Related:
- Change the text colour based on the value in the cell
- Crimping colour code - Guide
- How to change the dino in the dino game - Guide
- Change the scrolling of the document to vertical - Guide
- Change computer name cmd - Guide
- How to change language in kmplayer - Guide
2 responses
mdazgt
Posts
8
Registration date
Monday July 14, 2014
Status
Member
Last seen
July 19, 2014
Jul 15, 2014 at 10:44 AM
Jul 15, 2014 at 10:44 AM
take a copy of dev excel software
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 15, 2014 at 10:55 AM
Jul 15, 2014 at 10:55 AM
Hi Aravind,
For that we use conditional format.
Go to the Start tab and click on Conditional format and then Manage Rules.
Now click on New Rule and choose to use Formula.
Formula 1: =AND(A1>=-10,A1<=5)
Choose colour.
Add another rule.
Formula 2: =AND(A1>5,A1<40)
Choose colour.
Add another rule.
Formula 3: =AND(ISNUMBER(A1),A1>=40)
Choose colour.
Now that you have your 3 rules, you can adjust the range on which you want to apply the conditional format.
In the example below the range A1:D10 has been chosen.
Note: The formula's in the pic are Dutch.
Best regards,
Trowa
For that we use conditional format.
Go to the Start tab and click on Conditional format and then Manage Rules.
Now click on New Rule and choose to use Formula.
Formula 1: =AND(A1>=-10,A1<=5)
Choose colour.
Add another rule.
Formula 2: =AND(A1>5,A1<40)
Choose colour.
Add another rule.
Formula 3: =AND(ISNUMBER(A1),A1>=40)
Choose colour.
Now that you have your 3 rules, you can adjust the range on which you want to apply the conditional format.
In the example below the range A1:D10 has been chosen.
Note: The formula's in the pic are Dutch.
Best regards,
Trowa
