Can i make a formula that will Highlight a cell

[kerndogg]

Hi, new to the board. Looking forward to learning a lot here. I have what is probably a dumb question.
I have a large spreadsheet with many pieces of equipment in it. There are a few piece that I would like to highlight should thier computer license go out of date, or even better 30 days prior. I have a Feild with the Expire dates but it is at the end of the spreadsheet not in plain sight. Is there a way to make my Equipment description column highlight when the date in the other column reaches the current date (or 30 Days before). I have cut and pasted the part of the spreadsheet into a new file to make it easier to read and hid all the none important feilds.

[NBVC]

Select entire range from C3 down and go to Home tab and click Conditional Formatting, New Rule

Select Use a formula to determine which cells to format...

then enter formula:

=$AR3<=TODAY()

click Format and choose from the Fill tab.

Click Ok

Click Ok to end.

Note: Your description above and in your sample workbook do not exactly match... I went by the workbook sample problem description.

If you want as above, use: =$AR3<=TODAY()+30 instead

[masteff]

Or if you'll be adding rows in the future, you can highlight the entire C column and use the following in the conditional format:
=AND(AR1<=TODAY(),ISBLANK(AR1)=FALSE)

[kerndogg]

Awesome. Thanks for the quick reply? NBVC, just out of curiousity what are you talking about where my spreadsheet doesn't match my description?

[NBVC]

In your workbook you state:

When this date is on or past todays date I would like the description in Column C to Highlight!

and above you state:

Is there a way to make my Equipment description column highlight when the date in the other column reaches the current date (or 30 Days before)

the first you says to highlight anything before today's date.. the second highlight anything within 30 days from now and before...

[kerndogg]

I see. I worded it strange, but the +30 formula that you gave me was the right one for what I needed. Thanks for your help!

[freeSky]

Or if you'll be adding rows in the future, you can highlight the entire C column and use the following in the conditional format:
=AND(AR1<=TODAY(),ISBLANK(AR1)=FALSE)

Hi Masteff, I surf the web and saw ur interesting solution here, and i have a even big problem similar to this one, could u please help me to take a look. Thank you very much.

Here is the linkhttp://www.excelforum.com/excel-form...e-results.html