ExcelBanter - Conditional Formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formating (https://www.excelbanter.com/excel-discussion-misc-queries/159876-conditional-formating.html)

Jithu

Conditional Formating

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

Conditional Formating

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

On Sep 27, 7:32 am, Jithu wrote:
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

All times are GMT +1. The time now is 09:15 AM.