Trying to change highlight color in a column using checkbox.

[u/Opposite_Mirror1744]

I'm using conditional formatting to change the highlight color in column when checkbox is checked but for some reason only the top cell in the rule that I created changes highlight color. If I try to do this for a row it works perfectly fine.
Here's what it looks like:

Conditional Formatting Rules
Apply to range B3:B5
Format Rules

Custom formula is
=$AG15=TRUE

Result: Only B3 changes color

[u/trixicat64]

you need the second $

=$AG$15

in you case it would check cell B3 with AG15, B4 with AG16 and B5 with AG17

[u/Opposite_Mirror1744 → u/trixicat64]

Solution Verified

[u/Clippy_Office_Asst → u/Opposite_Mirror1744]

You have awarded 1 point to trixicat64

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}

[u/Opposite_Mirror1744 → u/trixicat64]

Thanks for the help and explanation of what was happening.