Conditional Formating

[Guest]

Hi,

Is it possible to give background colour for a cell, if it shows some
results(the cell contains a formula, with output True/False. I wish to do
this without VB.(Conditional formating etc)

Thanks in advance for your time.

Jithu

 

[DDavid]

in the conditional formating box (->format -> conditional formating)
select formula is: and evaluate the original cell you are
evaluating, and add the formating you want for TRUE, and the
formatting for FALSE