Użytkownik "smormando"
napisał w
wiadomości ...
Rather than confuse you with words, I'm going to attempt to show you
what I need to do through pictures. I think this will work a little
better.
The workbook I'm using is shown here...
http://www.altairav.com/steve/step1.jpg
If you're unclear what I'm attempting after looking at this second
picture, please let me know.
http://www.altairav.com/steve/step2.jpg
The actual sheet I'm working on is a bit bigger, I just wanted to
simplify the example. If I can get it to work on this little example,
I should be able to apply it to what I'm doing. I appreciate any help
someone can give me, even if it's just some direction.
Thanks in advance!
--
smormando
------------------------------------------------------------------------
smormando's Profile:
http://www.excelforum.com/member.php...o&userid=37297
View this thread: http://www.excelforum.com/showthread...hreadid=570118
if u want to change all cell colors into same one u can use conditional
formatting
but first u got to name range a2:b11 on sheet1
then go to 2nd sheet and in conditional formatting put formula ( a2 is
active cell )
=vlookup(a2;your name of range;2;false)<0 and format it as u wish and copy
it to the rest of range
hth mcg