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

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

-----Original Message-----

.

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


--
Marc.

"Jason Morin" wrote in
:

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

-----Original Message-----

.

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
=C41
(or whatever your criteria is)
click the format button
set the formatting
click OK twice

Cheers
JulieD



"Marc Fleury" wrote in message
77.134...
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


--
Marc.

"Jason Morin" wrote in
:

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

-----Original Message-----

.