Forum Discussion
Change text colour by condition
Could you help me to change text colour to "red", if the cell="Critical" by formula, thank you
You need conditional formatting. Try below formula in CF rule.
=D3="Critical"
Hello Bronze,
Could you help me to add one condition which is "Completed" as below
=D3="Critical" & not "Completed", then color will be red
aother scenario D3="Critical" & "Completed", then color will be green
Thank you
Best regards,
Justin
