Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - If day = 24 or 25
Hi All,
Is there a way to format a cell based on the day of the month? I'd like the cell colour to change if it's the 24th or 25th of the month. Thanks if you know. Michele |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - If day = 24 or 25
Michele,
Suppose your dates are in column D, starting with D2. Highlight the cells from D2 down, then bring up the CF dialogue box. Select Formula Is rather than Cell Value Is in the first box, and enter this formula: =OR(DAY(D2)=24,DAY(D2)=25) then click on the Format button and choose your background colour from the Patterns tab. OK your way out. Hope this helps. Pete On Jan 26, 1:17*am, mjones wrote: Hi All, Is there a way to format a cell based on the day of the month? I'd like the cell colour to change if it's the 24th or 25th of the month. Thanks if you know. Michele |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - If day = 24 or 25
On Jan 25, 8:22*pm, Pete_UK wrote:
Michele, Suppose your dates are in column D, starting with D2. Highlight the cells from D2 down, then bring up the CF dialogue box. Select Formula Is rather than Cell Value Is in the first box, and enter this formula: =OR(DAY(D2)=24,DAY(D2)=25) then click on the Format button and choose your background colour from the Patterns tab. OK your way out. Hope this helps. Pete On Jan 26, 1:17*am, mjones wrote: Hi All, Is there a way to format a cell based on the day of the month? I'd like the cell colour to change if it's the 24th or 25th of the month. Thanks if you know. Michele Thanks for replying. I need to clarify though. I meant the actual day, like today() knows the actual date. The date is not in a cell. Is this still possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - If day = 24 or 25
In that case you would use this formula:
=OR(DAY(TODAY())=24,DAY(TODAY())=25) Hope this helps. Pete On Jan 26, 1:27*am, mjones wrote: Thanks for replying. *I need to clarify though. I meant the actual day, like today() knows the actual date. *The date is not in a cell. Is this still possible? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - If day = 24 or 25
On Jan 25, 8:41*pm, Pete_UK wrote:
In that case you would use this formula: =OR(DAY(TODAY())=24,DAY(TODAY())=25) Hope this helps. Pete On Jan 26, 1:27*am, mjones wrote: Thanks for replying. *I need to clarify though. I meant the actual day, like today() knows the actual date. *The date is not in a cell. Is this still possible? Great. Thanks!!!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - If day = 24 or 25
You're welcome, Michele - thanks for feeding back.
Pete On Jan 26, 1:49*am, mjones wrote: Great. *Thanks!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |