Following is the data i have
Capture.JPG
AND FOLLOWING RESULT I WANT BY USING CONDITIONAL FORMATTING
Capture123.JPG
PLEASE TELL ME THE WHATS THE FORMULA USE IN CONDITIONAL FORMATING. I M USING EXCEL 2007
Following is the data i have
Capture.JPG
AND FOLLOWING RESULT I WANT BY USING CONDITIONAL FORMATTING
Capture123.JPG
PLEASE TELL ME THE WHATS THE FORMULA USE IN CONDITIONAL FORMATING. I M USING EXCEL 2007
Last edited by sharadmaxwell; 04-27-2016 at 04:40 AM.
Hi, welcome to the forum
What exactly are you trying to do here?
Youe sample answer does not match your sample data?
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
Select the A column then put
=B2="Holiday" in conditional formatting
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
hmm OK I think I see what you have there. Use this as teh CF rule...
=vlookup($F2,$A$2:$B$8,2,0)="Holiday"
using your formula wrong result shows.
it showing like bleowCapture123.JPG
Actuly Sir
in Date i have a list of holidays i.e on which date holiday comes
in another file i have list of dates
so i want to highlite the date on which holiday comes
i hope you understand
no sir its not working
see the imageCapture123.JPG
Upload a sample file
sample file attched
It worked fine for me?
Select the F Column then put in conditional formatting formula =VLOOKUP(F2,A2:B8,2,0)="Holiday".
Check the attachment.
THANKS
FDibbins & shukla.ankur281190
BUT I DONT KNOW WHY THIS FORMULA NOT WORKS IN MY FILE
SEE IMAGE 2.JPG
I ATTCAHED FILE ALSO - NAME "MY FILE"
Thanks everyone who help me
its solve now,
thanku very much friends
What was the problem?
Did you set the Applies To range to be the same as the VLOOKUP range?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks