Conditional Formatting Problem

[al_rwli]

I understand the basics of conditional formatting, however, I stil
can't seem to get a *different cell* to change once onother cell i
greater than 20.

For example:

If A10 is anything over 20 (Cubic Feet) then I would like D10 (Th
shippers name) cell to be BLUE.

Thanks for any help.

Also, Thank you Mr. Kabel for help with my original conditiona
formatting problem.

Sincerely,
A

Attachment filename: example list.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65016

 

[Frank Kabel]

Hi
-select cell D10
- open the conditional format dialog
- choose 'Formula' and enter the formula
=A1>20
- choose your format