Can I make a formula such as "If c4 value > 1, then (shade pink)"

J

Jason Morin

1. Select the C4.
2. Go to Format > Conditional Formatting.
3. Select Cell Value Is | greater than ... and put 1.
4. Click the Format radio button and format as desired.

HTH
Jason
Atlanta, GA
 
M

Marc Fleury

I think the question was if C4 is not the cell to be formatted.

I.e. is there a way to change the format of one cell based on the value of
another cell
 
J

JulieD

Hi

"is there a way to change the format of one cell based on the value of
another cell?"

yes, (unfortunately, i can't see the original question) but assuming you
want to format D4 based on the value in C4 click in D4 and choose
format / conditional formatting
choose
formula is
choose
=C4>1
(or whatever your criteria is)
click the format button
set the formatting
click OK twice

Cheers
JulieD
 
Top