•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
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#row zero
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#google sheets
#Excel alternatives
#Conditional Formatting
#boolean
#zero value
#Excel
#SUM formula
#greater than 49
#conditional rule
#gold
#PM
#PLD