• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting

B

Browny Boxer

New Member
Hi,

Attached EXCEL file contains the EMI Description, Tenure of EMI, EMI amount and the running EMIs throughout.

My requirement is as and when the system date moves to 11th every month, I want the cells to be changed as GREEN and the font as black. For example on 10th April, I would like to have the corresponding Cells (From AA12 to AA21) should become GREEN & font in black).

Help me out and my advance thanks...

Ganesh Manchi
 

Attachments

Hi Ganesh ,

It is not clear from your post why on April 10 , the cells AA12 through AA21 should be formatted ; can you explain at least another 2 cases , such as :

On May 11, 2014 which are the cells which would have been coloured ?

On January 11, 2015 which are the cells which would have been coloured ?

Narayan
 
You must log in or register to reply here.
Back
Top