Thanks, i changed your code little bit and it worked
Sub create_conditional_formatting()
Range("b1").Select
With Sheet1
With .Range("B1:E5")
'.FormatConditions.Add xlExpression, Formula1:= _
'"=COUNTIF($A$1:$A$5,B1)=0"
.FormatConditions.Add xlExpression, Formula1:= _
"=IF(trim($A1)=trim(B1),TRUE,
Basically I want to compare a cell to a reference cell(range A) in the same
sheet and highlight that cell
for example
A B C D
Home HomeHotel Hotel
Hotel Airport
Hi All
I'm trying to write an excel vba code that return a number with respct to
the value of the 2nd number.
There are 5 number copied into one column(it has to be one column,project
requiremnt)
and if the value of 2nd number in cell1 is -995.25 and 2nd number in cell2
is > 1
it returns the
Here is a sample file with 2 example sheets
On Monday, July 8, 2013 1:43:08 PM UTC-5, ha...@mst.edu wrote:
>
> Hi All,
> Basically, I want to find a text from specific category and return the
> text/number to a specific cell.
> For example,
> API NUMBER: (return the value here)
> Find API number
Hi All,
Basically, I want to find a text from specific category and return the
text/number to a specific cell.
For example,
API NUMBER: (return the value here)
Find API number from the following text(be aware:API # is always 10 numbers
separated by dashes e.g. nn-nnn-n)
-
Hi, thanks for the file
but I got run time error 53. File not found?
On Tuesday, June 25, 2013 11:45:20 PM UTC-5, Francis Mukobi wrote:
> Basole > wrote:
>
> >Hamood, post your PDF file and tell what data you want to import
> >
> >
> >
> >Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha..
Hello,
I hope you're having a good day.
I would like some help in my project involving imprting some data from pdf
into excel spredsheet.
It involves creating a button in excel to load the pdf file and copy some
pre-selected data into excel.
Can anybody help me in how I should approach the proje
