simple excel formula required

No3ntry · 22 Dec 2011 at 00:45

I need to run a macro that will look for the value in U3 and then find that value in column a and change the colour of the text.

If it helps, the value I will be searching for will always be present and will only appear once.

Thanks
James

Tomsk · 22 Dec 2011 at 07:37

Use conditional formatting

Malakite · 22 Dec 2011 at 11:41

Putting this formula in beside you values in column a will tell you if the value beside it matches your value in U3

=IF(VLOOKUP($A$1,$U$3,1,FALSE)=$U$3,"Match","")

Alternativly as said above just use conditional formatting to change the colour of the values in A:A if they match U3

No3ntry · 25 Dec 2011 at 22:39

Cheers guys never thought of using conditional formatting.