Dear all,
I wanna use the Conditional Formatting to highlight for Date like the atttached
How to do it,
Thanks in advance,
vumian
Dear all,
I wanna use the Conditional Formatting to highlight for Date like the atttached
How to do it,
Thanks in advance,
vumian
Last edited by vumian; 09-22-2009 at 12:55 AM.
You're making us guess at why you highlighted those three cells. Why not explain what makes them special?
Is it just "highlight the first instance of each date" ?
Last edited by JBeaucaire; 09-21-2009 at 02:08 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Yes, i wanna to highlight the first instance of each date,
Thanks for your help
If so, the CF formula for that would be:
=COUNTIF($B$3:$B3,$B3)=1
Thanks JBeaucaire so much,
I have a question harder for me, please help me again
I wanna use CF to highlight the number of Maximun for each date as eg
Thanks in advance,
Last edited by vumian; 09-21-2009 at 02:54 PM.
The CF formula for that would be:
=E3=SUMPRODUCT(MAX(($B$2:$B$100=$B3)*($E$2:$E$100)))
Dear JbeauCare,
You are so great, thank you so much,
vumian
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks