How do you Control the fill color using an if statement formula?

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

Guest

I'm trying to make an interactive calendar that will operate by changing the
fill color of the day. The user does this manually, but I want the formulas
in the sheet to read and react to this. I thought that I saw it before, but
I'm not sure how it was accomplished.
 
Hi,

You could use conditional formatting, for example, highlight the range of
dates and choose the command Format, Conditional Formatting and open the
first drop down and change to Formula is and in the second box enter
=C4=TODAY()
Where C4 is the active cell of the selection. Click the Format button and
choose a color on the Patterns tab.
 
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

Can Excel's field fill colors be changed using "IF" statements? 2
Counting by color 3
color of cell fill 2
CF to Color-Fill Row B:G w/Specific Text in One of the Cells 1
Logic Formula using colors in the formula? 2
How to retain part of formula's criteria as static 7
Getting a fill color on a certain date 2
Error Installing "ADAPTEC EZCD 4.04" 1

Back
Top