Dear All,
here i want to color my cell based on their dates for example : 01-Jan-2014 to 10-Jan-2014.
for the respective date i want to color my bars from G10 to P10.
any assistant will be highly appropriated.
thanks.....
Dear All,
here i want to color my cell based on their dates for example : 01-Jan-2014 to 10-Jan-2014.
for the respective date i want to color my bars from G10 to P10.
any assistant will be highly appropriated.
thanks.....
hi Victor. select the range you want to apply to (say from G8:BM26)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND(G$3>=$D8,G$3<=$E8)
format colour
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Dear benishiryo,
would you please apply it in attached sheet.
thanks....waiting for your feedback
If we do all the work for you, you will never learn how to do it yourself
Ben has shown you what you need to do, try and do it for yourself
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
i appreciate your thoughts,
in this regard i tried but its not working......now can you please help me with attached sheet.
thanks.....
What did you try, and what happened?
Remove the double quotes in your CF formula. It then will work. When entering a CF formula you have to add the equal sign yourself, otherwise, XL puts it between double quotes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks