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
Hi,
I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. The cells in the row need to change to a different colour should the selection in the dropdown box change.

e.g. cell range A5:H5 to be red if C5 = declined, or green if C5=won

I also require the same formatting to rows 6 downwards

Any help would be appreciated

Jim
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0