Conditional formatting of one cell depending on other cell.

Hi !!

Is it possible to format a cell conditionally depending on the value of another cell ?

For eg. If P3 contains X as a data in cell then A3 changes to red & If P3 contains Y as data in cell A3 changes to blue, similarly if P3 contains Z as a data in cell then A3 changes to green.

Whilst in cell A3, do:-

Format / CF / change 'cell value is' to 'formula is', =$P$3="X"

Choose your font/pattern combination etc and you are done.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"Little Master" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi !!
>
> Is it possible to format a cell conditionally depending on the value of
> another cell ?
>
> For eg. If P3 contains X as a data in cell then A3 changes to red & If
> P3 contains Y as data in cell A3 changes to blue, similarly if P3
> contains Z as a data in cell then A3 changes to green.
>
>
> --
> Little Master
> ------------------------------------------------------------------------
> Little Master's Profile:
> http://www.excelforum.com/member.php...o&userid=28227
> View this thread: http://www.excelforum.com/showthread...hreadid=480324
>

Thanks ken !!

You're welcome :-)


"Little Master" <[email protected]>
wrote in message
news:[email protected]...
>
> Thanks ken !!
>
>
> --
> Little Master
> ------------------------------------------------------------------------
> Little Master's Profile:
> http://www.excelforum.com/member.php...o&userid=28227
> View this thread: http://www.excelforum.com/showthread...hreadid=480324
>