Do i need to use VBA?

  • Thread starter Thread starter Confused Man
  • Start date Start date
C

Confused Man

Hello all,

I have a worksheet inside a large spreadsheet that has a listing of dates
and prices that it pulls from the other worksheets in the file. I want to
set it us so that if the date in column "C" is todays date make the cell
BOLD and a certain color... if the date occured within the past 30 days no
bold but the same color... and then a separate formule that does the same
thing in column "N" but gives a different color (bold only on todays date)

Is this possible? and if so... how?

Thank you all so much!
Confused Man
 
Use conditional formatting

select the cells in C
Format>Conditional Formatting
Change condition 1 to Formula Is
Add a formula of =C1=TODAY()
Click Format
On the Font tab, selct Bold
On the Pattern tab, select your colour
OK
Click Add condition
change to Formula Is again
Add a formula of =C1>TODYA()-30
repeat for bold and colour
OK
 
Thanks that's perfect!

Confused Man

Bob Phillips said:
Use conditional formatting

select the cells in C
Format>Conditional Formatting
Change condition 1 to Formula Is
Add a formula of =C1=TODAY()
Click Format
On the Font tab, selct Bold
On the Pattern tab, select your colour
OK
Click Add condition
change to Formula Is again
Add a formula of =C1>TODYA()-30
repeat for bold and colour
OK
Click to expand...
 
Back
Top