Conditional formatting

[Paul Orton]

How do I colour an individual cell based on the content
of another cell? Conditional formatting seems only to do
this based on the content of the cell you want to
conditionally colour.

Or have I missed something?

Best wishes,
paul.

 

[Gord Dibben]

Paul

You have missed something.

Select the cell for CF(say A1)

Format>CF>Formula is: =b1=123

Choose a format and OK your way out.

When B1 is 123 A1 will be formatted.


Gord Dibben Excel MVP