Conditional Formatting - zero returns boolean true
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to make conditional formatting exclude blank cellsMaking a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows: I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example): Total time F5 =IF(D5;E5-D5;"") Number format: Time Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended. My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that? I appreciate all the help! submitted by /u/ace_098 [link] [comments]
- Why does my conditional formatting appear random?This is for school (homeschooling. I don't have access to quick or direct contact with a teacher, which is why I'm here). I've received a video of instructions for how conditional formatting works, and I feel like I'm doing what was in the video. But the formatting seems to get applied randomly. Here, I need to colour the product name based on if column E is less than 5 Here, I need to colour the rows based on if column P is \"WAAR\" Did I write the formula wrong? Is it something else? submitted by /u/Independent-Total861 [link] [comments]