Change colour of range of cells based upon text from a drop down menu in another

Solved
Report
Posts
1
Registration date
Tuesday April 20, 2021
Status
Member
Last seen
April 20, 2021
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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