Struggling to write a Iif or Switch statement in the expression for the following:
If the cell value is "Y" then nothing
If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.
IIF(Column="y",Nothing,IIF(DATEDIFF("d",TODAY(),[SV3Date])<10,"Red","Black"))
??