Change color of cells based on expiry date

Conditional formatting is what you need..

Can you attach a sample Workbook?

Deep

how does the IF formula know if an indate or an outdate

as far as excel cell is concerned, it will just be a date (i assume)
and so how you populate that date based on if IN or OUT will depend on the rules in the IF statement
OR
do you have on the cell next to the date - the words "in date" or "out date"

a sample spreadsheet attached would also help

for 2007 or 2010 excel version
Conditional Formatting

Highlight applicable range >>

Column G


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=G1="in date"


Format… [Number, Font, Border, Fill] use fill green
choose the format you would like to apply when the condition is true
OK >> OK

repeat for
=G1="out of date"
and use fill red

see attached

your welcome, thanks for the rep

can you upload the spreadsheet with the issue in

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

so thats different to the original question
and as a diffrent user - you should really start a new thread of your own
and then in the sample

Would like to see a manual mock up of the expected results you want to achieve.

Asking questions in other peoples threads gets confusing , as indeed I did by not looking closely at the "thread starter"

no problem - create a new thread and I will answer there

hiren1312, welcome to the Forum. As a new user, please take the time to review our rules. There aren't many, and they are all important.

If you have a follow-up question on the same solution that was given to another user you can ask that question, but your case you are asking a question about your own file. In that case we ask that you simply start a new thread with your question. Below is the formal statement of the rule.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.