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
How to change a row color based on a text value in a cell
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.