Tryingtoresolve
New Member
- Joined
- Aug 28, 2023
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
I am trying to get one cell update another colour E2 contains a dropdown with 2 different statements On Hold and Sales M2 contains the destination figures
On hold I want to add a colour when it's greater than 120
Sales I want to add a different colour for when it's over 30
I can get conditional formatting to work the normal way but not by instructing it with a comment
On hold I want to add a colour when it's greater than 120
Sales I want to add a different colour for when it's over 30
I can get conditional formatting to work the normal way but not by instructing it with a comment