Forum Discussion
Sjohnson1975
Mar 27, 2024Copper Contributor
Copying Conditional Formatting referencing a different cell
Is it possible to copy a conditional formatting changing the reference cell each time: Example: I want to highlight the value whenever the cell value of F6 is not between -G6 and G6. then I...
HansVogelaar
Mar 27, 2024MVP
The rule doesn't change - it shows how it applies to the first cell in the range.
But the formula ="k6" should be =K6
Anyhow, you should apply this rule to a range in another column. There is no point in comparing K6 to K6 itself
Sjohnson1975
Mar 27, 2024Copper Contributor
I am comparing the range of the cell done negative value to positive value, -40 to 40. Wanting the cell to highlight if the result is outside that range. The range will change with every row. I am not putting the “” around the cell excel is doing that automatically when I close out of the conditional formatting page
- HansVogelaarMar 27, 2024MVP
Which column contains the cells you want to highlight?
Which column contains the values you want to compare to?
- Sjohnson1975Mar 27, 2024Copper Contributor
The column I want to highlight is f and the one i want to compare to is g, from negative of that number to positive.
- HansVogelaarMar 28, 2024MVP
If you want to highlight values outside the range from -Gn to +Gn:
See the attached workbook.