•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting - zero returns boolean true
I have a column populated by numbers generated by a formula in a different sheet (I know, it's complicated)
for example:
Let Sheet 1 be called PM. Let Sheet 2 be called PLD.
There is a SUM formula on PLD that adds together the values in several cells.
My formula compares numbers in columns on both sheets, and returns the SUM from PLD to PM.
THE PROBLEM:
Here's where it gets weird!! There is a Conditional Formatting rule that colors the values greater than 49 as gold (=>49 is gold.) Of the SUM return value is between 1 & 49 it works just fine, but if the value is zero then it colors the cell gold. Why does it activate for a zero value when the Conditional formula states =>49??
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#formula generator