Highlight cell when date is over/expire

[najanjua]

Good Day

this forum is always helpful for me when ever i m in trouble... thnx for all who respond..

today need ur help again ..

1. i am working on worksheet 2013 having data ... with reports names and dates and other information as well.. i need a formula in which cell will be highlighted itself when dates is over/expire .. in any case either we enter the date or date is already existed in cell.. so we can easily follow up for concerned dept.. tht its due ..

2. if 1st prblm iz solved thn i need to expend this as .. row highlighted

thnx

 

[adkock]

Use conditional formatting:

Say your table is in Columns A:G, with your relevant date in column A. Select the entire table and make sure cell A1 is active. Go to the home ribbon and select "Conditional Formatting". Select "New Rule" and subsequently "Use a formula to determine which cells to format". Enter the following formula:

=today() > $A1

Next, click format and select a suitable format to indicate the highlighted rows. Click ok.

 

[Boller]

Assuming date is in A1, select row 1 and use the formula "=Now()>$A1" in conditional formatting.

 

[najanjua]

Sorry Adkock .. it is not working
below is mine sheet .. i need something which only highlight the cell which is expire or due date is over ...

[TABLE="width: 621"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 7"]ACTION PLAN DISCUSSED DURING Meeting[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]S. No[/TD]
[TD]ABC #[/TD]
[TD]Ref. No[/TD]
[TD]Issue[/TD]
[TD]Action to be Taken[/TD]
[TD]By Whom[/TD]
[TD]Due Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]223365[/TD]
[TD]1[/TD]
[TD]AAAAAAAMMMVVV[/TD]
[TD]GGGGGDGDGD[/TD]
[TD]XYZ[/TD]
[TD]23-Feb-16[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1233[/TD]
[TD]2[/TD]
[TD]GGGG[/TD]
[TD]HGFHH[/TD]
[TD] PMU[/TD]
[TD]23-Feb-16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4569[/TD]
[TD]2[/TD]
[TD]ERTETT[/TD]
[TD]YRYRYR[/TD]
[TD] PMU[/TD]
[TD]23-Feb-16[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]1313[/TD]
[TD]1[/TD]
[TD]DGDG[/TD]
[TD]GDGDGDG[/TD]
[TD]DGDG[/TD]
[TD]10-Mar-16[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]34434[/TD]
[TD]5[/TD]
[TD]T3535[/TD]
[TD]ETETET[/TD]
[TD]PEDO/AGP[/TD]
[TD]15-Apr-16[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]343434[/TD]
[TD]1[/TD]
[TD]No issues[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]15-May-16[/TD]
[/TR]
</tbody>[/TABLE]

 

[najanjua]

Sorry it is not working Boller ..

 

[adkock]

Good Day

this forum is always helpful for me when ever i m in trouble... thnx for all who respond..

today need ur help again ..

1. i am working on worksheet 2013 having data ... with reports names and dates and other information as well.. i need a formula in which cell will be highlighted itself when dates is over/expire .. in any case either we enter the date or date is already existed in cell.. so we can easily follow up for concerned dept.. tht its due ..

2. if 1st prblm iz solved thn i need to expend this as .. row highlighted

thnx

Sorry Adkock .. it is not working
below is mine sheet .. i need something which only highlight the cell which is expire or due date is over ...

Now I am confused...the solution I gave to you highlights the entire line, as your requested in your original post...

Looking at the example you posted, apparently the date you want to check is apparently in column G.

Select the entire column G and make cell G1 active by ctrl clicking on it; add conditional formatting with the formula

=AND(NOT(ISBLANK($G1)),TODAY()>$G1)

In case you are not familiar with conditional formatting, please see New Conditional Formatting Rule - Excel Easy

 

[najanjua]

Many thanks for all your help...