Paul

You have missed something.

Select the cell for CF(say A1)

FormatCFFormula is: =b1=123

Choose a format and OK your way out.

When B1 is 123 A1 will be formatted.


Gord Dibben Excel MVP

On Tue, 21 Dec 2004 16:15:32 -0800, "Paul Orton"
wrote:

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.