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
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
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