Hi dear i dont have access to open other website

"MartinW" wrote:

Hi Dinesh,

Upload a sample file at this site and then post the link
to your file back here. That way everyone can see
your problem.
http://www.savefile.com/

HTH
Martin


"Dinesh" wrote in message
...

Actually i mot getting ur solution please provide me ur mail id i will
send
u the sample data or u can mark me a mail on

"MartinW" wrote:

Hi Dinesh,

Here is a beginning.
With your data in A1 to Ewhatever
Select all of your data
Then set Conditional Formatting with Formula is:
=$C2=TODAY()

This will highlight the entire row when you put a date
in column C that is greater than or equal to today.

This will only work if column C is blank and
doesn't contain the - in your example.

If this doesn't help you please post with more detail
particularly what is in the Eff. Till column.

HTH
Martin


"Dinesh" wrote in message
...
Hi I want to do when todays date meet with eff. till date then the
color
of
whole row changed.

From To Eff Till Seat Capacity Daily Capacity
AMD CCU 15-Apr 180 180
AMD DEL - 180 180
AMD PNQ - 180 180
BBI BOM - 180 180
BBI CCU - 180 180
BBI DEL - 180 154

Please do the needful,

Thanks with regards in advance,
Dinesh