Jul 14 2020 06:26 AM
Can you change the whole row colour based on the formatting of a particular cell?
Formatting cell colour is being changed, according to the status of that cell, but we need the whole row to change colour, rather than just the cell, is this possible?
Jul 14 2020 06:54 AM
Jul 14 2020 07:09 AM
Thank you, I have attached below a screenshot, you can see ‘Status’ is where the conditional formatting is set up, and this works great, however they would like the whole row ‘C-K’ to be formatted, to change colour as the status is changed, not just the cell ‘K’
Kind Regards
Jul 14 2020 10:35 AM
Jul 14 2020 11:51 AM
SolutionTo do so, select the range C11:K23 (as per your screenshot) and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.
=$K11="Progress"
While the range is still selected, make similar rules for other status and set the different format as per the Status.
Jul 14 2020 11:51 AM
SolutionTo do so, select the range C11:K23 (as per your screenshot) and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.
=$K11="Progress"
While the range is still selected, make similar rules for other status and set the different format as per the Status.