Changing colors?

[Guest]

I have a worksheet that has a list of medication in column A with their
corrisponding expiration dates in column B. How can I make the dates in
column B change to red when the current days date is within 60 days of the
expiration date shown? Will it do this?

 

[David McRitchie]

Hi Lee,
Use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Select Column B that would make cell B1 the active cell.
The formula you use is based on the active cell.

Format, Conditional Formatting
Formula is: =$B1+60 < TODAY()
press the large formatting button
you can change the Font color and/or the interior pattern color

By placing a $ in front of the B1 that limits the test to the B column,
so you could select all cells on the sheet and use that formula if you
wanted to color the entire row as every cell on the row would use that
formula to test, and the row would be adjusted on subsequent rows.