Can a cell change color based on the value of another?

G

Guest

I would like to have the fill color of one cell change based on the
comparison of values in two other cells. For example, if the number in C4 is
larger than the number in C3 can C5 turn red?
 
B

Bob Phillips

Use conditional formatting in C5 with Condition 1 of Formula Is and a
formula of

=C4>C3

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

PCLIVE

Conditional formatting on C5. Format-Conditional Formatting.
Select FormulaIs.
=C$4>$C$3

Thsn set your format colors from the format button. Changing the cell
background is Pattern.

HTH,
Paul
 

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

Change Color of cell 3
Changing the Status of Cell 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
How to set text color based on value in cell compared to constant 3
Can RGB fill color be automated based on 3 cell values? 2
Changing the color of a cell based on the color of another cell. 6
Changing a color in a cell based on the text in another cell 3
change cell color depending on two cell values 1

Top