Conditional Formatting row by row

[jimithing007]

Hello,

I have a spreadsheet with Columns A-Y. There will likely be thousands of rows, and Row 1 contains my headers. Column K features a drop-down menu with a handful of selections. One of the selections is "None." If "None" is selected on any row, there is no need for data in columns K-X, so I want to gray those columns out.

I tried this with Conditional Formatting, but I can't figure out how to apply conditionally for every row. I found a formula that works for just one row, but if I apply it to the whole sheet, the whole sheet's K-X turn gray if only cell K2 is selected as "None." How do I get it to apply independently for each row's selection?

Thanks in advance.

 

[Joe4]

Highlight the exact range you range you want to apply it to, and then write the Conditional Formatting formula as it pertains to the very FIRST cell in your selected range.
If you have used mixed references correctly, it will automatically adjust for all other cells.

So, if selecting columns K-X starting on row 2, the formula would look something like:
=$K2="None"
Note how column K is locked down, but the rows are allowed to float.

 

[jimithing007]

Success!

I was either trying to highlight all of K in the formula, or I had the range selected incorrectly. Either way, works now. Thanks Joe4!

 

[Joe4]

You are welcome!