Why dont you post few sample data or explain how the data is arranged...

--
Jacob (MVP - Excel)


"Rohinikumar" wrote:

In the excel sheet I just highlighted colors manually but I want auto formula
like in the first sheet some vehicles doesnt have some documents then we
mentioned No with yellow colour and Yes in green color, later 15 days again
we have to audit the same vehicles then we compare both sheets that time if
same documents have in the same vehicle then it will come in green color if
not the document it will come to in red color. Is it possible?

"Jacob Skaria" wrote:

Check out this link on Conditional formatting with dates

http://www.mrexcel.com/articles/due-...formatting.php

--
Jacob (MVP - Excel)


"Rohinikumar" wrote:

Hello All,

I hope some one expert can help my problem...that is i have excel book for
two sheets in sheet one some coloumns "NO"with back ground highlited Yellow
colour.that is every 15days we have checked our vehicles if some documets are
not we will mention NO.after 15days again we have to check same vehicles that
day also if it is not the same documets automaticly it will come No with Red
colour background????i want to know how it is possible...if you are not
understand just give me your mail id i will send you the excel sheet.pls help
me for my great future in my office.