a question re conditional formatting in excel

  hatrickj 18:56 18 Nov 2004

Is it possible to conditionally format a cell depending on a value or string in another cell and the to be formatted cell contains a value
cell A1 = 2
cell B2="xxx"
cell A2 is to be formatted to colour -green

  VoG II 18:58 18 Nov 2004

Yes. In the dialog box for Conditional Formatting there is a drop-down box. Select Formula Is then enter a formula like:


  Megatyte 19:24 18 Nov 2004

If you want to run the test for multiple cells then use..




You can use up to 30 arguments, each one seperated by a comma.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?