Change colour of range of cells based upon text from a drop down menu in another
Solved/Closed
Jim1409
Posts
1
Registration date
Tuesday 20 April 2021
Status
Member
Last seen
20 April 2021
-
20 Apr 2021 à 16:56
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 Apr 2021 à 11:52
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 Apr 2021 à 11:52
Related:
- Excel change row color based on dropdown selection
- How to change row color in excel based on dropdown selection - Best answers
- Excel drop down list with colored cells - Best answers
- Excel color formula - Guide
- Saints row 2 cheats - Guide
- How to change text color in html - Guide
- Color 65535 - Guide
- Notepad++ change background color - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
22 Apr 2021 à 11:52
22 Apr 2021 à 11:52
Hi Jim,
For that we use Conditional Formatting.
First select cells A5:H5. Go to Conditional Formatting found on the Start ribbon and choose to add a rule. Then choose to use a formula (bottom option). Enter the following formula:
=$C5="won"
and apply the green color.
Repeat for the next formula:
=$C5="declined"
and apply the red color.
With A5:H5 still selected, drag the range down as far as you want to apply it to those rows as well.
Best regards,
Trowa
For that we use Conditional Formatting.
First select cells A5:H5. Go to Conditional Formatting found on the Start ribbon and choose to add a rule. Then choose to use a formula (bottom option). Enter the following formula:
=$C5="won"
and apply the green color.
Repeat for the next formula:
=$C5="declined"
and apply the red color.
With A5:H5 still selected, drag the range down as far as you want to apply it to those rows as well.
Best regards,
Trowa