+ Reply to Thread
Results 1 to 8 of 8

Conditional Format (highlight each april)

  1. #1
    Registered User
    Join Date
    08-26-2009
    Location
    Lima, Peru
    MS-Off Ver
    Excel 2007
    Posts
    37

    Question Conditional Format (highlight each april)

    Hi,

    First thanks for your time!

    I'm trying to do something rather easy (I think). I would like to conditional format a column of historical dates. In this column I would like to highlight the first month of each fiscal year (April).

    I'm unsure how to type this in logically into the conditional format formula? (Excel 2007).

    I tried "=Month()=4" which does not work. Sometimes I wish we could just use simple algebra to do excel functions! A=Month(x) when A = 4, format cell!


    Any ideas?

    Thanks a ton,
    Mike
    Last edited by mworonuk; 09-25-2009 at 01:10 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Conditional Format (highlight each april)

    Your formula should look like: =Month(A1)=4

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Conditional Format (highlight each april)

    Try in A1

    =(MONTH(A1)=4)

    Where A1 is the cell you want to highlight
    Then use Format painter to copy it to other cells
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    08-26-2009
    Location
    Lima, Peru
    MS-Off Ver
    Excel 2007
    Posts
    37

    Smile Re: Conditional Format (highlight each april)

    Thanks for the help, this works.

    I was however trying to format the whole column at once... the paint format helped make it easy to copy the formatting down though.

    Just to confirm, you cannot do this with one condition that tests the whole column for Month()=4 ?

    Thanks everyone!

  5. #5
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Conditional Format (highlight each april)

    For whole column..

    put cursor in A1

    then click on column heading A to select the entire column and enter the same formula as mentioned above...

    it will be automatically copied down the entire column

  6. #6
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Conditional Format (highlight each april)

    For whole column..

    put cursor in A1

    then click on column heading A to select the entire column and enter the same formula as mentioned above...

    it will be automatically copied down the entire column
    Yes. But do you really want to apply the format to 1-millions rows? The OP is using 2007. IMO, this puts an unncessary overhead burden on Excel.

    Click once in A1, then press Ctrl+Shift+down arrow to select all cells in the column down to the last used cell and enter the formula in the CF. Adjust the last cell reference to a greater number to pad the range with extra cells.

  7. #7
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Conditional Format (highlight each april)

    Quote Originally Posted by Palmetto View Post
    Yes. But do you really want to apply the format to 1-millions rows? The OP is using 2007. IMO, this puts an unncessary overhead burden on Excel.

    Click once in A1, then press Ctrl+Shift+down arrow to select all cells in the column down to the last used cell and enter the formula in the CF. Adjust the last cell reference to a greater number to pad the range with extra cells.
    You are correct. it put extra load .. I thougth the OP wanted to format whole column thats why I suggested this method

  8. #8
    Registered User
    Join Date
    08-26-2009
    Location
    Lima, Peru
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Conditional Format (highlight each april)

    Thanks for all the help everyone. How do I mark this thread as "SOLVED"?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1