Is there a formula to AUTOMATICALLY highlight a specific month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Select all the cells, goto to Format>Conditional Formatting, and set the
option to Equal to and a value of 3.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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!
 
Try inputting a formula in the conditional formatting =month(a1)=3
If it works copy and paste formatting only to relevant cells
 
In that case, use a formula of =MONTH(A1)=3

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to do this? 2
Subtotaling a Varied length Spreadsheet 1
Excel Highlight date ranges 1
highlight a column 4
conditional format -- if not a date, then highlight cell 1
Excel Excel 'end of month' datedif and Conditional formatting 1
Select rows equal to filter and highlight row 4
automatically highlight a row when a cell in that row is selected 4

Back
Top