Need a formula for a conditional formatting of a cell based on another cell's data

Question

I'm trying to highlight a cell based on another cell's data

Example:

  A               B
 100% (green)     1
   0% (red)       1 or greater
   0% (white)     0

So I need to conditional column A so that if it shows 100% Green, 0% with a 1 or greater in B Red, and if it's 0% with a 0 in B white.

Any Ideas?

Your tag indicates maybe you are using excel for Mac? Which version? — bjbk, Nov 13, 2015 at 15:57
@BrandonWard I edited your question. Please check if it is fine like it is now. Also add the possible values (e.g. integers or (0|1|2)) in column B. — klanomath, Nov 13, 2015 at 16:03

klanomath · Accepted Answer · 2015-11-13 16:06:55Z

1

Sounds like Conditional Format is what you are looking for.

Select the cell which have to be formatted and choose Format->Conditional Format in the menu of Excel.

klanomath

65.4k9 gold badges127 silver badges196 bronze badges

answered Nov 13, 2015 at 16:05

hirnwunde

5355 silver badges7 bronze badges

Add a comment |

1 Answer 1