Forum Discussion
Conditional Formatting background colour not working on all rows
You could assign the blank value to 'N/A' or 'NV' which isn't a bad practice to have and will solve your problem for now. Are you using status column for Lookup table?
There are three status columns in three seperate tables, design, print, production which all link back to a quotations table via JobID. The Overall Status also links back to the quotations table via JobID. These are pulled from SQLServer.
I have fixed the problem where if there is a null value in the respective status tables, it is replaced with 'none', but now I have the issue that there are a few other columns with blank cells as I have the table set to show items with no data which also causes the problem. See below screenshot. is there a way to simple replace all blnk cells in the table visualization rather than having to address the issue in the table view?
The conditional formatting should work regardless of there being blank cells. We shouldnt have to be creating workarounds. This seems like a bug.