How to color cells based upon a value in another cell

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!
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
# Value error and how to ignore blank cells 2
Setting the number of Tabs in a Tab Control 0
how to copy paste the figures in adjoining cells? 0
Program buttons to create a word document 0
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Automatically populate value of cell dependent on adajecent cell 3
Word macro that can call cells out of Excel for a find and replace 0

Top