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


  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
  • 1
    @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

1 Answer 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.

For more information have a look at: use a formula to apply conditional formatting

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .