How do I create one conditional formatting rule for a specific range of rows/columns

Options
Evan I
Evan I ✭✭
edited 08/22/23 in Smartsheet Basics

I have a sheet that has the 1st row and 1st column of data that Im using to do a countifs in another sheet. The full set of rows/columns is about 10,000 cells. I want to set up conditional formatting based on the number in the cell to create a heatmap. For example, 25-50, light yellow, 51-100, yellow and so on. There would be 6 ranges in total.

Right now, I have to create one rule for each range for each row, this would be 108 rows times 6 ranges, so 648 rules. There has to be an easier way.

Additionally, my first row is part of my countifs so I dont want that row included in the conditional formatting.

How do I set up one rule for specific rows/columns so I only have 6 rules for the whole sheet?

Answers