Forum Discussion
Justin Hsu
Nov 18, 2024Copper Contributor
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"
- Harun24HRBronze Contributor
You need conditional formatting. Try below formula in CF rule.
=D3="Critical"
- Justin HsuCopper Contributor
Hello Bronze,
Thank you very much for help😀
Have a good day
- Harun24HRBronze Contributor
Glad to know!
- Justin HsuCopper Contributor
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
- Justin HsuCopper Contributor