| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight the cell date of current month
If Any Row having different due dates , So I want a Conditional formula for
showing current month dates highlighted. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight the cell date of current month
You want something like:
=month(a1)=month(today()) Regards, Fred. "kashish" wrote in message ... If Any Row having different due dates , So I want a Conditional formula for showing current month dates highlighted. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight the cell date of current month
=AND(E10,MONTH(E1)=MONTH(TODAY()))
If you are new to CF 1. Select the cell/Range (say E1:E10). 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the formula. Please note that the cell reference E1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: If Any Row having different due dates , So I want a Conditional formula for showing current month dates highlighted. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight the cell date of current month
Better to include year...
=AND(E10,TEXT(E1,"mmyyyy")=TEXT(TODAY(),"mmyyyy") ) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: =AND(E10,MONTH(E1)=MONTH(TODAY())) If you are new to CF 1. Select the cell/Range (say E1:E10). 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the formula. Please note that the cell reference E1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "kashish" wrote: If Any Row having different due dates , So I want a Conditional formula for showing current month dates highlighted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight a row with the current date. | Excel Worksheet Functions | |||
| highlight current date | Excel Discussion (Misc queries) | |||
| Current date formula based on month | Excel Discussion (Misc queries) | |||
| calendar highlight current date | Excel Discussion (Misc queries) | |||
| Pulling a date in the current month | Excel Worksheet Functions | |||
Linear Mode
