Conditional formatting is not functioning correctly

JClarke

Hi,

I created some conditional formatting in a task sheet. Unfortunately, it is not working. I created 4 rules and none of them are appearing on the sheet itself. I have created these 4 rules in other sheets and they work exactly as intended. I am not sure what is going on.

Your help with this would be appreciated.

markkrebs

is your intent to only format the gantt bar? if so, hard to tell what's wrong without access to the sheet.

Ray Lindstrom

The colors you assigned for the whole row are white background with black text. You chose gantt chart bar colors also. Did you mean to use the "fill" feature for formatting the row? If so try this: