| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell Background
Miguel
You should use conditional formatting to do that. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Cell Background
On 8 dec, 14:33, Ixtreme wrote:
Miguel You should use conditional formatting to do that. Something like: =A1NOW() --- Red and =AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) ------ Orange |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Cell Background
On Dec 8, 1:54*pm, Ixtreme wrote:
On 8 dec, 14:33, Ixtreme wrote: Miguel You should use conditional formatting to do that. Something like: =A1NOW() * --- Red and =AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) * * *------ Orange I am using Excel 2007. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Cell Background
On Dec 8, 1:54*pm, Ixtreme wrote:
On 8 dec, 14:33, Ixtreme wrote: Miguel You should use conditional formatting to do that. Something like: =A1NOW() * --- Red and =AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) * * *------ Orange Sorry for the multiple messages. I was trying the new Google Groups and I kept getting an error when posting. And somehow Google stored my trials and posted all at once. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Cell Background
On Dec 8, 1:58*pm, Shapper wrote:
On Dec 8, 1:54*pm, Ixtreme wrote: On 8 dec, 14:33, Ixtreme wrote: Miguel You should use conditional formatting to do that. Something like: =A1NOW() * --- Red and =AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) * * *------ Orange Sorry for the multiple messages. I was trying the new Google Groups and I kept getting an error when posting. And somehow Google stored my trials and posted all at once. I was trying Conditional Formating and used the following: Selected the Cells then: Conditional Formatting Highlight Cell Rules A Date Occurring Next Month This works if the date in the cell is in the Same Year and next month. But if the date of the cell is 06-01-2011 and today is 08-12-2010 then this does not work. Any idea? Thank You, Migurl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Background Color Change -- Change Event | Excel Programming | |||
| Trying to change the background of a cell if I type a certain wor | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| background color of my cell does not change | Excel Discussion (Misc queries) | |||
| can't change cell background? | Excel Programming | |||
Hybrid Mode
