Well, you can do a couple of things. One would be to use an older technique
that is a little tricky, but very doable. Follow these steps:

Hit Ctrl + F3
Name: TheFormula
Refers to: =GET.CELL(6,INDIRECT("RC",FALSE))
Hit Add
Hit Ok

Then select your cell in col B, goto Format (menu) | Conditional Formatting
| Formula Is ...
=TheFormula="="&ADDRESS(ROW(),COLUMN()-1,4)
This will check the formula in the cell in column B, if it says "=A1" (or
therow it is in) then the condition is true.

Another method contains using a UDF ...

Function MyFormula(Optional celRef As Range)
If celRef Is Nothing Then Set celRef = Application.Caller
MyFormula = celRef.Formula
End Function

Then use this conditional format for column B...
=MyFormula()="=A"&ROW()


--
Regards,
Zack Barresse, aka firefytr


"snax500" wrote in message
oups.com...
Thanks but your formula doesn't work if both column A and C are equal.
Any other ideas.