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,"")

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