Change cell color

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

How do you change a cell's color with an "IF" statement. I can produce
conditional text with an "IF" statement, but don't know how to effect the
formating in the cell.
 
Nel post *Alan* ha scritto:
How do you change a cell's color with an "IF" statement. I can produce
conditional text with an "IF" statement, but don't know how to effect
the formating in the cell.
Click to expand...


Use Conditional Formatting (menu Format, Conditional Formatting), choose
FormulaIs under Condition 1 and in textbox type your formula, starting with
"=" (without quote).

Take care that the formula you type must have a results TRUE or FALSE...

If you want more help, post the formula you want to use and give us more
specifications. You can also see the on line help about Conditional
Formatting.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thank in advance for your feedback.


Ciao

Franz Verga from Italy
 
You must log in or register to reply here.

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

Excel Macro to automatically go to the right of the last colored cell 0
Is there a way to count colored cells that are conditionally formatted? 3
Excel VBA 1
Automatically change the text format the cell when use a specific text 10
Count of Font Format 1
Non-macro method (like conditional formatting) to insert text in cell? 7
Change Format of Active Cell 1
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0

Back
Top