Tryingtoresolve
New Member
- Joined
- Aug 28, 2023
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
I am struggling with a conditional format to work I'm trying to get one cell to change colour if higher than another I can make this work but I'm trying to get it to ignore N/A within the column I've tried using this =IF(O2>U2),"N/A) it accepts it and changes the cell where its higher Qty than U2 but still highlights N/A within the cell as well