Cell formatting issue

WillH

Hi,

I seem to be having an issue with cell formatting. I have set up formatting for cells to turn red/green, I then added a rule to make the whole row white if the date in the date column is in the future...

For some reason although the white row rule is at the top it is not applying this above the others?

Thanks, Will.

Paul Newcome

Double check that you actually selected white for the cell fill. If you do not select anything, it applies no cell fill and the other rules can still function.

Using the snippet below:

"No background" is the default. You have to make sure you actually click on the white cell fill option.

Carson Penticuff

Did you check to make sure the top rule is actually set to "white background" and not "no background"? I only ask because I recently had this exact issue and it took me several hours to troubleshoot.

Paul Newcome

Double check that you actually selected white for the cell fill. If you do not select anything, it applies no cell fill and the other rules can still function.

Using the snippet below:

"No background" is the default. You have to make sure you actually click on the white cell fill option.

WillH

Thank you both, this was the issue!

All working great now 😊

Paul Newcome

Happy to help. 👍️