User Profile
Charlie585
Copper Contributor
Joined Apr 19, 2023
User Widgets
Recent Discussions
Re: Conditional formatting for entire row based on data in one cell
SergeiBaklan I hope you can help me, I have created a conditional rule eg. if A1 is higher in value than B1 it should highlight green but if its lower than it should highlight red, I know want to drag it down across the entire sheet but what's happening is that all formulas are based on the same B1 instead I need each row of A to compare to the same row in B (so A5 compares to B5), I have tried adding :$A$700 but that didn't work either - Please help416KViews0likes16Comments
Recent Blog Articles
No content to show