Shade the last 3 days in color .. help!
Solved/Closed
Related:
- Shade the last 3 days in color .. help!
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Skype last seen days ago - Guide
- Five nights in anime 3 - Download - Adult games
- Hitman 3 free download - Download - Action and adventure
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 20, 2010 at 07:27 AM
Jul 20, 2010 at 07:27 AM
is this same as your last question on the subject or a different one ?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 20, 2010 at 10:16 PM
Jul 20, 2010 at 10:16 PM
You can use conditional format using this formula
=OR($C1=LARGE($C:$C,1),$C1=LARGE($C:$C,COUNTIF($C:$C,LARGE($C:$C,1))+1),$C1=LARGE($C:$C,COUNTIF($C:$C,">=" & LARGE($C:$C,COUNTIF($C:$C,LARGE($C:$C,1))+1))+1))
in this C column has the date. The issue with you sample data is that date in your sample is text that only looks like a date. If you can have this in date format ( you can still have it formatted as yyyy-mm-dd but let it be a date) you can use the above formula
=OR($C1=LARGE($C:$C,1),$C1=LARGE($C:$C,COUNTIF($C:$C,LARGE($C:$C,1))+1),$C1=LARGE($C:$C,COUNTIF($C:$C,">=" & LARGE($C:$C,COUNTIF($C:$C,LARGE($C:$C,1))+1))+1))
in this C column has the date. The issue with you sample data is that date in your sample is text that only looks like a date. If you can have this in date format ( you can still have it formatted as yyyy-mm-dd but let it be a date) you can use the above formula
Thanks for your reply.
However, after i changed the date format by "Data>Text to columns>Next>Next>Column Data Format>Date>YMD and Finish" and applied the above code (after selecting column F to M) in conditional formatting, none of the cell got shaded. *I did change all the "C" to "K" in the code*
And i would like to know if the above code is designed for changing the rows of the last 3 date?Then what can i do to the rest( those that i need to change to yellow)?
Thank you very very much.
However, after i changed the date format by "Data>Text to columns>Next>Next>Column Data Format>Date>YMD and Finish" and applied the above code (after selecting column F to M) in conditional formatting, none of the cell got shaded. *I did change all the "C" to "K" in the code*
And i would like to know if the above code is designed for changing the rows of the last 3 date?Then what can i do to the rest( those that i need to change to yellow)?
Thank you very very much.
Jul 20, 2010 at 07:47 PM
i know it sound familiar, but i guess this one is a bit more challanging as the range of date is " irregular".
Jul 20, 2010 at 08:28 PM