Conditional Formatting in Excel 2007

qwertyiop

I need some help. I'm tasked with creating a excel spreadsheet to include all our workstations and warranty date.


I'm using Excel 2007 and I would like to create a function to color the warranty date cell to the color red if the warranty date has passed.


Could somebody help me with this?

astorrs

They've made it super easy now in Excel 2007.

Select the cells you want to use conditional formatting on, then on the Home tab click Conditional Formatting and pick New Rule, then configure it like this:



Click OK and you should be set.

qwertyiop

thanks alot for the help, it worked