Ask Your Question
0

calc conditional color of character [closed]

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 reopen merge delete

Closed for the following reason duplicate question by richramik@yahoo.com
close date 2019-08-09 14:42:41.253855

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

Question Tools

1 follower

Stats

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

Seen: 37 times

Last updated: Nov 07 '18