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