Hilight differences in column???????

M

malycom

Hi

I have a worksheet with currency information for clients. I have a problem in that I need to be able to run a formula next to the currency column to show differences. I have two sterling currencies, one being GBp and the other being GBP - Uppercase & Lowercase p.

How can I run a formula that will place the word delete in bold and in red next to any instance in the column where the word is all uppercase, ie GBP.

Thanks in advance

Malcolm
 
F

Frank Kabel

Hi
try
=IF(EXACT(A1,"GBP"),"Delete","")
and format this column with bold and a red color
 
Top