a question re conditional formatting in excel

  hatrickj 18:56 18 Nov 2004
Locked

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
e.g.
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:

=B2="xxx"

  Megatyte 19:24 18 Nov 2004

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

=AND(A1=2,A2="xxx")

or

=OR(A1=2,A2="xxx")

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

AH

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 ?