Forum Discussion
Solved
Conditional Formatting on multiple rows
Hi All, I have a spreadsheet where i need rows to auto 'grey-out' when that row is marked as closed in a cell on the row. I have worked out the conditional formatting for a single row but can'...
- Take the $ off of the 3 so the formula for the applied to range of A3:z1000 will all be based on the upper left cell (A3) so
=($G3="CLOSED")
which mean always use column G but move row 3 to be the same row as the cell being checked.
Take the $ off of the 3 so the formula for the applied to range of A3:z1000 will all be based on the upper left cell (A3) so
=($G3="CLOSED")
which mean always use column G but move row 3 to be the same row as the cell being checked.
=($G3="CLOSED")
which mean always use column G but move row 3 to be the same row as the cell being checked.
- Ah amazing, thank you! That's worked perfectly 🙂
(i've never truly got to grips with the purpose of the $'s so this change hadn't occurred to me)
