Microsoft lists conditional formatting dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3186001%22%20slang%3D%22en-US%22%3EMicrosoft%20lists%20conditional%20formatting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3186001%22%20slang%3D%22en-US%22%3ECan%20anyone%20help%20please.%20I%20have%20set%20up%20conditional%20formatting%20on%20a%20date%20so%20it%20shows%20as%20red%20for%20anything%20that%20is%20older%20then%20todays%20date.%20We%20also%20have%20a%20status%20field%20in%20the%20same%20list%20which%20is%20to%20show%20open%20and%20closed%20actions.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%20as%20some%20of%20our%20records%20are%20closed%20in%20the%20status%20field%2C%20the%20date%20field%20will%20still%20show%20the%20date%20formatted%20as%20red%20like%20it%E2%80%99s%20overdue.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20anyway%20this%20field%20can%20be%20shown%20a%20different%20colour%20as%20the%20status%20field%20is%20closed%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3186001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Can anyone help please. I have set up conditional formatting on a date so it shows as red for anything that is older then todays date. We also have a status field in the same list which is to show open and closed actions.

However as some of our records are closed in the status field, the date field will still show the date formatted as red like it’s overdue.

Is there anyway this field can be shown a different colour as the status field is closed
0 Replies