Conditional formatting can check data on an other sheet. Just create a name
for that data (InsertNameDefine Name...), or use INDIRECT, such

=B2=INDIRECT("Sheet2!A1")

BTW, do you have Excel 97?

--
HTH

Bob Phillips

"McManCSU" wrote in
message ...

This is probably a stupid question, but what do you have to do
differently to have a macro that runs at real time? What I need is to
change data fields depending on what a drop down menu has on it. I
tried cond'l formatting, but it doesnt let me grab data from a
different sheet... So now I need to make it real time..

Thanks


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile:
http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=392555