close
I want to carry format (colour) and text to a cell depending on outcome of a
logic formula. Please help.
You can make the text appear in the cell by means of a formula like
this:
=IF(condition,A1,quot;quot;)
You have to provide the logical condition, then the text will be
brought from cell A1 (for example).
If you want colour, just format the cell, as you will have a blank if
the logical condition is not met. Alternatively, you can use Format |
Conditional Format and then set up a logical condition and change the
foreground and/or background colour using this.
Hope this helps.
Pete
全站熱搜
留言列表
