Forum Discussion
How to hide rows if a cell value is above a specified value from a different cell?
Like this, but in formula it shall be relative reference for the row, not absolute. Other words $A14, not $A$14. And it shall be first (most top left) cell of your range
Please see attached, "not visible" region is in grey.
If by conditional formatting you may use the rule with formula
=$A1>=$C$4
applied to your entire range and using Fill=White/Font Color=White format
Hi SergeiBaklan. Thanks for replying.
Silly question, but what cell would I put it in? Can it not be done as a formula with an IF, such as:
IF cell value > C4, hide all rows that occur afterwards
I tried this, but nothing changes.
You can see that I have put your formula, with white formatting, to be applied to my entire dataset.
What am I doing wrong? Many thanks.
Like this, but in formula it shall be relative reference for the row, not absolute. Other words $A14, not $A$14. And it shall be first (most top left) cell of your range
Please see attached, "not visible" region is in grey.
Thanks so much SergeiBaklan. I managed to get it working.
Good, you are welcome