Need a formula for a conditional formatting of a cell based on another cell's data 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?
Sounds like Conditional Format is what you are looking for.

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

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