conditional formating - Help
Hi
Can Anyone help me with this I want excel to highlight the far most date from today in red, and next far most in yellow in a following table like this... XXXX 01 Nov 2008 14 Nov 2008 12 Oct 2008 06 Nov 2008 31 Oct 2008 |
conditional formating - Help
Suppose your dates are in A1:A5
For A1 you could use conditional format with following formula as criteria1: =A1=LARGE($A$1:$A$5,1) Choose red as cell color. For criteria2 you can use =A1=LARGE($A$1:$A$5,2) Choose yellow as cell color. Now use the format painter and copy the format of A1 down to A5. Make sure that the dates are "real" dates recognizable by Excel, not just text. Joerg "Kinghart" wrote in message ... Hi Can Anyone help me with this I want excel to highlight the far most date from today in red, and next far most in yellow in a following table like this... XXXX 01 Nov 2008 14 Nov 2008 12 Oct 2008 06 Nov 2008 31 Oct 2008 -- Kinghart |
Quote:
|
1 Attachment(s)
can u help me with this..... I'm attaching it
|
conditional formating - Help
Your're welcome. Thanks for the feedback. Still curious though how you found
the farthest date with the SMALL function... "Kinghart" wrote in message ... Joerg Mochikun;755534 Wrote: Suppose your dates are in A1:A5 For A1 you could use conditional format with following formula as criteria1: =A1=LARGE($A$1:$A$5,1) Choose red as cell color. For criteria2 you can use =A1=LARGE($A$1:$A$5,2) Choose yellow as cell color. Now use the format painter and copy the format of A1 down to A5. Make sure that the dates are "real" dates recognizable by Excel, not just text. Joerg "Kinghart" wrote in message ...- Hi Can Anyone help me with this I want excel to highlight the far most date from today in red, and next far most in yellow in a following table like this... XXXX 01 Nov 2008 14 Nov 2008 12 Oct 2008 06 Nov 2008 31 Oct 2008 -- Kinghart - Thanks Buddy.... Ur formula was very useful though it didn't get what I wanted.... but I modified it (Large to Small) and got what I wanted. (i.e. the far most dates from today) :-) +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Kinghart |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com