[SOLVED] Grey out row columns B — N, if status = Closed (with picture)

[johanna0507]

Hi! On a risk register, see picture, I would like to grey out the whole row, if status in column M=Closed.
This is to mark that the risk no longer needs to be actively monitored.

Example from picture: Row 10 has the status of Closed, based on the value in M10 (i.e Closed).

How would I make it so that on row 10, columns B - N are greyed out once I select Closed from the dropdown?

[Glenn Kennedy]

Using Conditional formatting, like this maybe...

[NeedForExcel]

You can use Conditional Formatting to do that..

Select Range B7 to N99 (Whatever) > Alt>O>D > New Rule > Use Formula To Determine > =$M7="Closed" > Set Desired Format

[johanna0507]

Thanks both for the feedback! NeedForExcel's advise immediately achieved what I wanted!

[NeedForExcel]

Glad it helped..

Please mark the thread as solved if you have your answer..

Cheers!

Deep