Question re: Column Properties

Windy W.

Hello Group,

I have a template with column properties set up to change cell colors, based on whether an item slated for completion had been done or not. I've created several sheets based on my template, but there appears to be an inconsistency between different sheets. The column is set up so that if you go to the column menu —> Edit Column Properties —> click on hyperlink for Edit conditional formatting rules, this is how the rules appear on both sheets:

However, notice the two separate sheets with one behaving correctly (with cells changing color based on due date) and the other with 3 cells in white (instead of turning to green, yellow, or red, based on due date).

Can anyone look at this and see what may have happened here, to cause the second sheet to NOT have the conditional formatting applied to the cells (despite the column properties matching EXCATLY between the two sheets)?

Thanks in advance!

SteyJ

Hi @Windy W.

Have you tried moving your conditional formatting for the color you want to see to the top of the list?

It looks like you might have another conditional formatting option overriding the yellow.

Windy W.

Hello @SteyJ,

I just tried moving it and there was no change.

Thank you,

Windy

Paul Newcome

Do those rows match any of these requirements?