Ask Your Question
0

calc conditional color of character

asked 2018-11-07 18:10:31 +0200

richramik@yahoo.com gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-11-07 20:38:34 +0200

updated 2018-11-07 20:41:57 +0200

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")))
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-07 18:10:31 +0200

Seen: 25 times

Last updated: Nov 07 '18