Conditional Formatting Problem

  • Thread starter Thread starter al_rwli
  • Start date Start date
A

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
 
Hi
-select cell D10
- open the conditional format dialog
- choose 'Formula' and enter the formula
=A1>20
- choose your format
 
Back
Top