Forum Discussion
esmefarrow
Oct 21, 2026Copper Contributor
Conditional formatting
I'm making a rule to Highlight cells in Column AZ when the value is lower than Adjacent cells in Column P. For the most part it works except for two cells in AZ (1 shown as an example) that are high...
- Oct 21, 2026
SynthiaHong
Oct 23, 2026Brass Contributor
If the built-in conditional formatting rules aren’t giving you the result you need, try using a formula-based rule. It gives you more flexibility to highlight cells based on specific conditions, and you can apply it to an entire range. Just make sure the formula uses the correct cell references, especially if you’re using $ to lock rows or columns.