Change colour of range of cells based upon text from a drop down menu in another
Solved/Closed
Jim1409
Posts
1
Registration date
Tuesday April 20, 2021
Status
Member
Last seen
April 20, 2021
-
Updated on Apr 20, 2021 at 05:29 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 22, 2021 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 22, 2021 at 11:52 AM
Related:
- Change cell color based on dropdown selection
- How to make excel cell change color based on dropdown selection - Best answers
- How to change cell color in excel based on dropdown selection - Best answers
- Notepad++ change background color - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Change computer name cmd - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Change lg tv name - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 22, 2021 at 11:52 AM
Apr 22, 2021 at 11:52 AM
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