2.4.7.1 Conditional formatting

Options
anjacksonms
anjacksonms Member, ALL USERS Posts: 5 Occasional Contributor

Hello. I'm stuck on the conditional formatting for the Final Forecast line. I noticed that my formula for the line item forecast cf only results in 0 no 1's, I'm not sure how to fix this as my conditional formatting will not show blue if I don't have any 1's as a result. Formula - IF Initial Demand Forecast = Final Forecast THEN 0 ELSE 1

anjacksonms_0-1641618262557.png

 

Comments

  • anjacksonms
    anjacksonms Member, ALL USERS Posts: 5 Occasional Contributor

    Thank you.  I tried that but it didn't work. I'll keep playing with it though.