Conditional Formatting Skipping Random Rows

[PeeWhy]

Hello all,

Long time lurker, first time posting.

I have some conditional formatting rules setup to watch another column and obtain the background and text colors from that column.  I see on the resulting report that the conditional formatting is not being applied to random rows.  I have attached a sample of what I have setup.  The Job Status column bacground should all be the same color in this screenshot according to the Background Color column. Can someone advise me on how to resolve this?

EDIT:  I know it has something to do with the option to "Show all items with no data".  If i uncheck that option, all rows have the same color but the result does not show all jobs in my database.    I need it to apply to all rows, including rows with "no data".  As you can see from the screenshot, it SHOULD be applying to all rows but its not.

[PeeWhy · Accepted solution]

Ok i figured it out.  I had (2) columns with User Hours included on the visual.  Although I am not summing the Hours, it still caused issues since some of the values were Null.  I had to add (2) additional columns replacing the Null values with 0.  Once i did that, I removed the orignal Hours column with Null values and replaced it with the new one containing 0's into the visual.  That resolved my issue.