How to color cells based upon a value in another cell

  • Thread starter Thread starter sportjunkie42
  • Start date Start date
S

sportjunkie42

What I'd like to do is color cells F4 - F74 based upon the values in G4 - G74.

For example:
If F4 = G4 I want F4 to be grey.
If F20 > G20 I want F4 to be green.
If F74 < G74 I want F4 to be red.

Any help would be appreciated!
 
Hi,

Am Wed, 28 Aug 2013 08:29:40 -0700 (PDT) schrieb
(e-mail address removed):
If F4 = G4 I want F4 to be grey.
If F20 > G20 I want F4 to be green.
If F74 < G74 I want F4 to be red.
Click to expand...

look for Conditional Formatting. Use formula
and enter your conditions


Regards
Claus B.
 
Back
Top