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

Report
Posts
1
Registration date
Tuesday April 20, 2021
Status
Member
Last seen
April 20, 2021
-
Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 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
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
461
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!