H3 = XL
H16 = XL
H28 = XL
formula for conditional formatting
=H3="XL" works.
I tried =H3,H16,H28="XL" but doesn't work
H3 = XL
H16 = XL
H28 = XL
formula for conditional formatting
=H3="XL" works.
I tried =H3,H16,H28="XL" but doesn't work
Can you give more context to your situation?
Is what you showed, in Applies To, or in "Use Formula"?
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
"Use Formula"
Please see the attached screenshot
xl.PNG
Actually, the cell H$3 contains formula
=VLOOKUP(B$3,TblEvents,3,0),"")
I tried putting this formula in "use formula" but doesn't work,
not sure if its possible.
Thanks.
Try removing the $
=H3="XL"
Make sure your Applied To range covers all the cells you need to apply this to, eg H3:H28
If you want to chexk if all three cells contain XL try
=AND(H3="XL",H16="XL",H28="XL")
Did you try my suggestion on post #5?
I tried all methods but still can't figure it out.
Please see the attached sample file explaining my query.
Thank you.
You need three CF rules, one for each colour:
=IIFERROR(VLOOKUP(B$3,TblEvents,3,0),"")="H"
=IIFERROR(VLOOKUP(B$3,TblEvents,3,0),"")="M"
=IIFERROR(VLOOKUP(B$3,TblEvents,3,0),"")="L"
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ali, couldnt you do that without the iferror?
=VLOOKUP(B$3,TblEvents,3,0)="H"
etc?
Probably, yes.
Brrrrrrrrrrrrrrrrrrrrrrr. Spreadsheet full of merged cells
Thank you everyone... got it working.
You're welcome! Thanks for the rep.
Try this for the cell formula...
=IFERROR(VLOOKUP($B3,TblEvents,4,0),"")
and this for the CF rule
=VLOOKUP($B3,TblEvents,4,0)=H
You can copy that to the other rows, but you will need a rule for each M, H etc
Thanks FDibbins, your formula works... I have 6 rows and each row has 3 conditions (H, M, L).
I was hoping if COLUMN() or ROW() function could be used to make less CF rules.
You only need three rules applied to the whole range you wish to cover.
The 3 rules work for Row B$3, for Row B$26 I need to make the 3 rules again and 3 rules again for Row B$35
No you dont. Make up the 3 rules in the 1st cell, like I showed you - using the cell formula I showed as well.
You can then just copy that cell to the other locations.
Sorry FDibbins, it doesn't work.
formula in cell is
=IFERROR(VLOOKUP(B$3,TblEvents,4,0),"")
CF rule
=VLOOKUP(B$3,TblEvents,3,0)="H"
it only works in Row B$3, and I have to copy paste for Row B$15, B$26 and so on....
Sample file is attached to post # 18, you may give a try.
Thanks.
Your formulas are not quite the same as what I suggested....
Look at where the $ is in B3Try this for the cell formula...
=IFERROR(VLOOKUP($B3,TblEvents,4,0),"")
and this for the CF rule
=VLOOKUP($B3,TblEvents,4,0)=H
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks