conditional formatting
Assume that you are having the Date Values in A Column. Place the cursor in
A1 cell and press Cntrll+Spacebar and now the total A Column will be getting
selected. A1 should be the active cell (Active Cell will have a white
Background after selection also).
Excel 2003:-
Select FormatConditional FormattingCondition 1Formula Is
=AND($A1<"",DATEDIF($A1,TODAY(),"Y")=3)
Then Click the Format command button and choose your desired Font and
Pattern colour and give Ok€¦
Excel 2007:-
Click HomeConditional FormattingManage Rules
OR
Alt+O+D
Click New RuleSelect Use Formula to determine which cell to FormatFormat
Values Where This Formula is True Copy and paste the below formula
=AND($A1<"",DATEDIF($A1,TODAY(),"Y")=3)
Click OkApplyOk.
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"Teeny" wrote:
I have a column of dates and I want to highlight in red all dates that are
equal to and more than 3 years old
For example if the date is 02/10/04 this should be highlighted in red.
I would appriciate anyones help!
|