# Conditional Format (highlight each april)

1. ## Conditional Format (highlight each april)

Hi,

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

2. ## Re: Conditional Format (highlight each april)

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

3. ## 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

4. ## 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. ## 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. ## 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. ## Re: Conditional Format (highlight each april)

Originally Posted by Palmetto
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. ## Re: Conditional Format (highlight each april)

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

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

#### 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