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

=B2=INDIRECT("Sheet2!A1")

BTW, do you have Excel 97?

--
HTH

Bob Phillips

"McManCSU" <McManCSU.1t74eh_1123085423.666@excelforum-nospam.com> wrote in
message news:McManCSU.1t74eh_1123085423.666@excelforum-nospam.com...
>
> 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
>