Conditional Formatting - Extend 2-color Gradient to Adjacent Columns

[NDave]

I would appreciate help with extending a 2-color gradient that is based on a percentage column to the adjacent columns. Attached is an example. The actual spreadsheet has many more rows so it's not practical to do manually. Thank you.

 

[SanjayGMusafir]

I would appreciate help with extending a 2-color gradient that is based on a percentage column to the adjacent columns. Attached is an example. The actual spreadsheet has many more rows so it's not practical to do manually. Thank you.

Actually if you choose formula to Conditional Format, you can do that. The challenges are -

First, it will be not as fine gradient as your example shows.
Second, you have to fix slabs to conditional format - Like 0%, 25%, 50%, 75%, 100% and create separate rules for that.

 

[NDave]

Actually if you choose formula to Conditional Format, you can do that. The challenges are -

First, it will be not as fine gradient as your example shows.
Second, you have to fix slabs to conditional format - Like 0%, 25%, 50%, 75%, 100% and create separate rules for that.

Thanks Sanjay for the reply and suggestions. I was slowly coming to a similar conclusion. I'm a little surprised and disappointed that Excel wasn't set up to do it, considering that there are many times that you may want to highlight rows based on cell values from a specific column. Thank you.