Highlighted Text And/Or Cells

M

M.A.Tyler

Is it possible for an "if" statement to not only return a numerical result,
but to return that result in highlighted text? Or to a highlighted cell?

Thanks as always!!
 
B

BrianW

Hi
You can achieve this with conditional formatting. When the condition is true
then activate condition "A" if it is false then activate condition "B" else
activate "C".

Format>Conditional Formatting>Formula Is>action: input formular
=(B11="x")>Format >Font Style>Color - action:select red >
You can also put a boarder around the cell and have the cell format to a
color with the same condition.
Border - action:select outline >Patterns - action:select yellow

Happy formatting and keep smiling
 
G

Gary''s Student

Yes:

Select the cell and pull-down:

Format > Cell... > Font and pick something like Bold, etc.
 
Top