Conditional Formating question - Excel 2003

  • Thread starter Thread starter mac
  • Start date Start date
M

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
 
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
 
Wow,

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

Thanks Biff!!!!!

mac
 
Back
Top