How do I change font colour in an if command?
E.g
IF(A1gt;=10, quot;OKquot;, quot;NOT OKquot;{I want to display this text in another colour to
stand out})
You would have to do this with Conditional Formatting (from the Format
menu). Select the cell then Format Conditional Formatting and in the
panel Cell Contents type quot;NOT OKquot; then click the Format button and
choose your font/colour/effect and background colour (patterns tab),
then OK your way out.
Hope this helps.
Pete
E.g
IF(A1gt;=10, quot;OKquot;, quot;NOT OKquot;{I want to display this text in another colour to
stand out})
You would have to do this with Conditional Formatting (from the Format
menu). Select the cell then Format Conditional Formatting and in the
panel Cell Contents type quot;NOT OKquot; then click the Format button and
choose your font/colour/effect and background colour (patterns tab),
then OK your way out.
Hope this helps.
Pete
文章標籤
全站熱搜
