I have a spreadsheet that I am doing conditional formatting. The number of rows may vary on subsequent rows.
If there is an error identified by an "X" in column V, column Q is highlighted in yellow.
I am currently manually inputting to format rows $Q$2:$Q$151. Is there a way I can format so that I don't have to explicitly define each time based on the number of rows.
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…