a question re conditional formatting in excel

  hatrickj 18:56 18 Nov 04

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 04

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 04

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.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…