Conditional Formating question - Excel 2003

[mac]

Is there a way to trigger a Conditional Formatting based on the value of
another cell?

Example, if Cell B10 = 1 then Cell A10 background color change to Orange?

Thanks!
mac

 

[T. Valko]

Try this...

Select cell A10

Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=B10=1
Click the Format button
Select the Patterns tab
Select a color of your choice
OK out

 

[mac]

Wow,

This is something I didn't know I could do.... This is Great! I'll try it
at work tomorrow!

Thanks Biff!!!!!

mac