ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there a formula to AUTOMATICALLY highlight a specific month (https://www.excelbanter.com/excel-programming/347432-there-formula-automatically-highlight-specific-month.html)

chrismears

Is there a formula to AUTOMATICALLY highlight a specific month
 
I have an Excel spreadsheet and in it I enter dates (creating ledgers). We
highlight (manually) each line of data containing the March balances.

I'd love to use conditional formatting to do this for me, but can't figure
out how. The only thing I want it to be able to do is highlight
(pattern=yellow) any and every cell that contains the month march (it will
only be entered as a date code, so month=3).

Thanks
Chris

Bob Phillips[_6_]

Is there a formula to AUTOMATICALLY highlight a specific month
 
Select all the cells, goto to FormatConditional Formatting, and set the
option to Equal to and a value of 3.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chrismears" wrote in message
...
I have an Excel spreadsheet and in it I enter dates (creating ledgers).

We
highlight (manually) each line of data containing the March balances.

I'd love to use conditional formatting to do this for me, but can't figure
out how. The only thing I want it to be able to do is highlight
(pattern=yellow) any and every cell that contains the month march (it will
only be entered as a date code, so month=3).

Thanks
Chris




chrismears

Is there a formula to AUTOMATICALLY highlight a specific month
 
Tried this (no luck). Dates are complete (yyyy-mm-dd), but formatted to show
as only (mmm-yy).

tried to apply a conditional formatting formula, but either it highlighted
everything, or just nothing. Thanks for the help!


Gary Keramidas

Is there a formula to AUTOMATICALLY highlight a specific month
 
i used this in a formula

=MONTH($A1)=3

--


Gary


"chrismears" wrote in message
...
Tried this (no luck). Dates are complete (yyyy-mm-dd), but formatted to
show
as only (mmm-yy).

tried to apply a conditional formatting formula, but either it highlighted
everything, or just nothing. Thanks for the help!




JMKCT

Is there a formula to AUTOMATICALLY highlight a specific month
 

Try inputting a formula in the conditional formatting =month(a1)=3
If it works copy and paste formatting only to relevant cells

--
JMKC
-----------------------------------------------------------------------
JMKCT's Profile: http://www.excelforum.com/member.php...fo&userid=2939
View this thread: http://www.excelforum.com/showthread.php?threadid=49104


Bob Phillips[_6_]

Is there a formula to AUTOMATICALLY highlight a specific month
 
In that case, use a formula of =MONTH(A1)=3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chrismears" wrote in message
...
Tried this (no luck). Dates are complete (yyyy-mm-dd), but formatted to

show
as only (mmm-yy).

tried to apply a conditional formatting formula, but either it highlighted
everything, or just nothing. Thanks for the help!




chrismears

Is there a formula to AUTOMATICALLY highlight a specific month
 
To quote the Dire Straits song, "That's the way you do it!"

Tried it and it works wonderfully, I was so close. Thanks guys!

"Bob Phillips" wrote:

In that case, use a formula of =MONTH(A1)=3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chrismears" wrote in message
...
Tried this (no luck). Dates are complete (yyyy-mm-dd), but formatted to

show
as only (mmm-yy).

tried to apply a conditional formatting formula, but either it highlighted
everything, or just nothing. Thanks for the help!






All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com