How to fill a cell using an IF statement

  • Thread starter Thread starter Rudi
  • Start date Start date
R

Rudi

Is it possible to colour fill a cell if the answer of a IF statement is true.
I want to do this in order to create a time line effect.
 
Yes it is, use Format | Conditional Formatting from the menu toolbar.
Whether you use the 'Cell Value Is' or the 'Formula Is' option depends on how
things are set up on your worksheet/in the cells.

If you already have a formula in the cell to shade, then use the 'Cell Value
Is' option, and if you're just changing the shade based on the value in some
other cell, then use the 'Formula Is' option.
 
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

Question about conditional formatting of zeros in Excel 0
If statement for a range of cells 3
Counting of cells with a specific color filled 9
Precedent Cell 1
=if() statement -- test for any text in cell 2
IF/THEN Results 2
Series fill only copying and fill series greyed out 1
Conditional format for date 4

Back
Top