Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Conditional formatting in Excel 2010 2
condition format 2
Excel Conditional Formatting Removal 7
Excel Conditional Formating 2
Conditional formatting 3
Excel 2007 - A Conditional Formatting ?'s 1
Conditional Formatting - Excel 2003 2

Back
Top