software

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

Thanks as always!!

Hi
You can achieve this with conditional formatting. When the condition is true
then activate condition quot;Aquot; if it is false then activate condition quot;Bquot; else
activate quot;Cquot;.

Formatgt;Conditional Formattinggt;Formula Isgt;action: input formular
=(B11=quot;xquot;)gt;Format gt;Font Stylegt;Color - action:select red gt;
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 gt;Patterns - action:select yellow

Happy formatting and keep smiling
quot;Gary''s Studentquot; wrote:

gt; Yes:
gt;
gt; Select the cell and pull-down:
gt;
gt; Format gt; Cell... gt; Font and pick something like Bold, etc.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;M.A.Tylerquot; wrote:
gt;
gt; gt; Is it possible for an quot;ifquot; statement to not only return a numerical result,
gt; gt; but to return that result in highlighted text? Or to a highlighted cell?
gt; gt;
gt; gt; Thanks as always!!

Yes:

Select the cell and pull-down:

Format gt; Cell... gt; Font and pick something like Bold, etc.
--
Gary's Studentquot;M.A.Tylerquot; wrote:

gt; Is it possible for an quot;ifquot; statement to not only return a numerical result,
gt; but to return that result in highlighted text? Or to a highlighted cell?
gt;
gt; Thanks as always!!

Hi Brian, Thanks for the help. It worked like a charm!

quot;BrianWquot; wrote:

gt; Hi
gt; You can achieve this with conditional formatting. When the condition is true
gt; then activate condition quot;Aquot; if it is false then activate condition quot;Bquot; else
gt; activate quot;Cquot;.
gt;
gt; Formatgt;Conditional Formattinggt;Formula Isgt;action: input formular
gt; =(B11=quot;xquot;)gt;Format gt;Font Stylegt;Color - action:select red gt;
gt; You can also put a boarder around the cell and have the cell format to a
gt; color with the same condition.
gt; Border - action:select outline gt;Patterns - action:select yellow
gt;
gt; Happy formatting and keep smiling
gt;
gt;
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Yes:
gt; gt;
gt; gt; Select the cell and pull-down:
gt; gt;
gt; gt; Format gt; Cell... gt; Font and pick something like Bold, etc.
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;M.A.Tylerquot; wrote:
gt; gt;
gt; gt; gt; Is it possible for an quot;ifquot; statement to not only return a numerical result,
gt; gt; gt; but to return that result in highlighted text? Or to a highlighted cell?
gt; gt; gt;
gt; gt; gt; Thanks as always!!