Conditional formatting of one cell depending on other cell.

L

Little Master

Hi !!

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

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

Ken Wright

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]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting based on formula cell 6
CONDITIONAL FORMATTING QUERY 0
Conditional Formatting 1
Conditional formatting 2
Conditional Format based on value in other cell 4
Automatically change the text format the cell when use a specific text 10
Conditional Formatting 4
Conditional Formatting 1

Top