TheUnconquered
New Member
- Joined
- May 9, 2013
- Messages
- 29
- Office Version
- 2021
- Platform
- Windows
Hello,
I have a conditional format set up right now that works most of the time for my purpose, but not all the time. How it's set up now, is if the cell is less than or more than zero it formats the cell red. The problem I have is sometimes there is very small numbers showing up in the output of the formula (like 0.00000001, for example). I don't need it to match that perfectly to zero. If it's off by a $1, fine, it can show as red. If it's off by less than a $1, I don't need to know that. How can I set this up in conditional formatting?
I have a conditional format set up right now that works most of the time for my purpose, but not all the time. How it's set up now, is if the cell is less than or more than zero it formats the cell red. The problem I have is sometimes there is very small numbers showing up in the output of the formula (like 0.00000001, for example). I don't need it to match that perfectly to zero. If it's off by a $1, fine, it can show as red. If it's off by less than a $1, I don't need to know that. How can I set this up in conditional formatting?