Forum Discussion
Solved
Conditional Formatting Past Due Date
I want to show font color (Red) if the Due Date is Today or before today. Table name is TR_FSP_2 column is Date_Due. Case Name Date_Due Smith, j 10/06/2020 x, Greg 11/07/2022 Harris ...
It should be :
FormatColour = IF(Today() >= [Date_due], "Red")
tells us if it works
It should be :
FormatColour = IF(Today() >= [Date_due], "Red")
tells us if it works
I'm sure that would work. But I'm still getting an error:
says my DATE_DUE doesn't exist. Even though it does:
Your probem is that your're creating a measure and you should use a column for this formula. So it is not because your column doesn't exist, it's because a measure doesn't have a row context whereas the column will have a row context.
So if you create a new column (not measure) with the same formula it should work.
Let us know