Tryingtoresolve
New Member
- Joined
- Aug 28, 2023
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hi thanks for the formula for conditional formating to ignore N/A but I've just tested and and realised I need to ignore empty cells as well in U2 and not change the colour how do this the suppled formula is =AND(O2>U2,O2<>"N/A")