Last Day of the Month Conditional formatting

[aravindkm]

Hi All,

Could anyone please help in Conditional format the Last day of the month with Cell Colour as Blue.

Example as below.

Date	19	20	21	22	23	24	25	26	27	28
										Should Be in Coloured as Blue
										Should Be in Coloured as Blue
										Should Be in Coloured as Blue
										Should Be in Coloured as Blue
										Should Be in Coloured as Blue
										Should Be in Coloured as Blue
										Should Be in Coloured as Blue

<tbody>
</tbody><colgroup><col><col><col span="9"></colgroup>

 

[seguin85]

Assuming the 19th is in cell B1, this should work as a formula in conditional formatting:

=DAY(B1)>DAY(C1)

 

[Scott T]

In conditional formatting

=B1=EOMONTH(DATE(YEAR(B1),MONTH(B1),1),0)

 

[Marcelo Branco]

To get the last day of February 2017 you can use this formula
=DAY(EOMONTH(DATE(2017,2,1),0))

So to use it in Conditional Formatting, assuming the days are in B1:K1, do
Select B1:K1
Home > Conditional Formatting > New rule
pick the second option: Format only cells that contains
cell value | is equal to | =DAY(EOMONTH(DATE(2017,2,1),0))

Hope this helps

M.

 

[snjpverma]

Assuming the 19th is in cell B1, this should work as a formula in conditional formatting:

=DAY(B1)>DAY(C1)

try the below formula in conditional formatting . Adjust the cell as per your data
=b1=eomonth(B1,0)