I'm hoping there's an easy answer using conditional formatting, but if not I'm fine with entering in some VBA.
A (starting at row 2) has a calculated position (an integer) based on certain criteria.
B (starting at row 2) has a hard-coded position (an integer).
I have conditional formatting on Column
B that will highlight the cell red (the "Bad" style format) if the value in
B is less than the value in
A. This works great. But I have many of these files and many rows in each file, so I don't want to have to scroll down each file to find a red highlighted cell. What I'd like instead is to highlight cell
A1 if ANY of the cells in Column
B are highlighted, i.e. are less than their respective
Is this possible with a conditional format in cell
A1? I've tried
COUNTIFS() but wasn't able to figure it out, don't know if that's the correct function I'm looking for.