View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Conditional formatting If then for date?

Hello

select all cells

on conditional format

change to the formula is

and use =month(a1)=month(today())

format as you need


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sueshe" escreveu:

I have a spreadsheet with data for each month in columns by month. I need
the current months data to show blue/bold and if it is not the current months
data to show black/non bold. Is there a way to do this? Would appreciate
any help, am trying to become more familiar with conditional formatting, but
haven't quite gotten the gyst of it.....would be a lot faster than having to
reformat each month. Thanks!!!