| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you Control the fill color using an if statement formula?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you Control the fill color using an if statement formula?
by the way, i'm running Excel 2002
"RussCrowder" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you Control the fill color using an if statement formula?
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. -- Cheers, Shane Devenshire "RussCrowder" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for a fill color help | New Users to Excel | |||
| How do you fill a cell with a color based on IFTHEN formula? | Excel Worksheet Functions | |||
| allow fill color to be changed or toggled using a formula | Excel Discussion (Misc queries) | |||
| can I use the 'fill color' as part of a formula | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Linear Mode
