atw: Excel: conditional formatting based on another cell

Hi all
Does anyone know of a way in Excel to put conditional formatting on a
cell based on the values of another cell? ie if Cell A has a certain
value, I want Cell B to have a certain format.

The only way I know puts formatting on a cell based on its own values.


Regards

Elizabeth Fullerton
Business Solutions Architect
Infosys Australia
Tel: +61 3 9911 3529
Fax: +61 3 9911 3407
www.infosys.com
Powered by Intellect
                 Driven by values



**************************************************
To post a message to austechwriter, send the message to 
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to 
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with 
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to 
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to 
austechwriter-admins@xxxxxxxxxxxxx
**************************************************

Other related posts: