calc conditional color of character

[richramik1]

Hey Gang:

I have the following in cell H43: =IF(H42="",“O”,“R”) OPEN or RESPONDED respectively.

The formula works just like I wanted. However, what I would like to do is have the O stand out in RED. What would be the easiest way to accomplish this?

Thanks,
Rich Ramik

[SM_Riga]

Hello. You can use STYLE function to apply predefined style to the cell. Documentation on the STYLE functions can be found here

Your formula could look like:

=IF(H42="";"O"&T(STYLE("Bad"));"R"&T(STYLE("Good")))