Conditional formating by origin

[Brisbane Rob]

Hello

A1 has value of 4. B1 has value of 5. C1 has a formula choosing the
bigger of the two values between A1 and B1 and is therefore showing 5.

Is there anyway of conditional formatting C1 to show the origin of the
value was from B1?

Anyone got any ideas?

Thanks

 

[Bob Phillips]

Yes.

Select A1 and B1
Format>Conditional Formatting
Formula of =A1=$C1
and format


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brisbane Rob" <[email protected]>
wrote in message
news:[email protected]...

 

[Brisbane Rob]

Thanks guys...so obvious when someone shows you how