Hilight differences in column???????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
try
=IF(EXACT(A1,"GBP"),"Delete","")
and format this column with bold and a red color
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement for equivalent value of a range 4
How do I set up vlookup so that it is case sensitive? 1
Table Lookup 4
Help please 4
SUMIF using cells with commas in 1
vlook/match/index 12
Currency automation 3
Complicated Macro - Someone please help.....this will definetly be a challenge!! 6

Back
Top