Hey guys

I have this logic expression in a spreadsheet

=IF(C19>C18,"YES","NO")

What i want to do is if it returns a value of NO make the text red.

Is this possible?

I have seen the conditional formatting, but i think this would only work with 2 cells with numbers in. So i could apply that to my C19 cell but not to another cell that is looking at both of those cells.

Hopefully someone can help

Thanks in advance