Let’s take a look.
Here we have the table of random numbers.
Let’s first build a conditional format that uses a formula to highlight cells greater than 500.
We can do using:
=B4 > 500
Remember to use the address of the active cell.
For format, I’ll use a green fill.
Now all cells with values greater than 500 are highlighted.
But notice that the number 500 is currently hard-coded into the formula.
So, if you want to change that number, you’ll have to edit the rule.
It would be a lot more convenient to expose that number on the worksheet as a variable.
To do that, I’ll first create an input cell and give it a label.
It’s easiest to select 500 and then click directly onto the worksheet.
Notice that Excel uses an absolute address.
But once I enter 500, the cells with values over 500 are highlighted again.
