User Profile
squirrel442
Copper Contributor
Joined 11 months ago
User Widgets
Recent Discussions
Help with conditional formatting
Below is the screenshot of my spreadsheet:- I’m currently on the tab Oct23, this is the start data. Next tabs is Nov23, Dec23 and so on. What I’m wanting to do is add the new data to Nov23 tab and have the cell colour change based on the number difference to Oct23. What I’m looking for is:- Red cell if -2 & below Light red if -1 No change if the same Dark green if +1 Light green if +2 & above The full spread sheet is:- Coloumns = A to AQ Rows = 2 to 99 How do I do this? I know its conditional formatting, but how do I set this up?
