hi all my friends,
i need your help in this case, i want to make conditional formating for a row in a table when i write the value of one its cells, and repeat this conditional formatting for entire table when i write the value in the entire column, i tried to use vlookup several time but i doesn't work properly
in this case i want to highlight entire row in table ( b7:i100) when i choose value in column k.
1) Highlight B7:I1000 (or however far down you want to go)
2) Apply this Conditional Formatting Rule:
New Rule > Use a Formula > =ISNUMBER(MATCH($F7,$K:$K, 0)) > Format > Fill > Yellow
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
@ JBeaucaire
Thanks alot, but it doesn't work properly with all rows, some rows are correctly formatted and other not, I uploaded the updated sheet,
thanks in advance
You only applied the CF rule down through row 255. Go to Conditional Formatting > Manage Rules, and adjust the range of that rule down as far as needed.
@ JBeaucaire
Thanks alotee, appreciate ur effort
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks