Excel Highlight

  • Thread starter Thread starter tress
  • Start date Start date
T

tress

Hi,

Think it might just be one of those days what I am trying to do is I have
one Excel Document with 2 Sheets in it, some values on Sheet 1 appear in
Sheet 2, when this happens I want to highlight the value in Sheet 2 either
with a colour or making the Value Bold I am using Excel 2003 on a Windows XP
machine.

Thanks P
 
Use conditional formatting with a formula of

=COUNTIF(Sheet2!$A$1:$M$100,A1)


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi,

Thanks for the reply, is there a way to change the return value from a 1
where there is a match to something like "Date Match"?

Thanks P
 
Hi there,

Thanks for the reply, is there a way to change what the return value on a
match is from 1 to something like "Date Match"?

Thanks P
 
It isn't matching 1, it is matching whatever is in A1.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi,

Thanks again for the quick reply, I have just tried it again and I am just
getting a one in the formula column wherever it finds a match, cant see what
I am doing wrong can you think of any reason for this.

Thanks P
 
And there is more than one? Have you adjusted the range?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Ben & Bob

Yes Ben that is what I am trying to do and Bob yes I have altered the range,
the code works fine if there is a value it shows 1 if not it shows 0, what I
have done is a bit of a quick fix, is hide the column that shows either the 1
or 0 and create an If function on a new column that says If 1 "Available"
otherwise "Not Available" I know its not the best way of doing things so I am
open to suggestions, I did try combining the 2 function in the same cell but
kept getting errors as I think I was getting the format wrong.

Thanks again for the help, P
 
=IF(COUNTIF(Sheet2!$A$1:$M$100,A1)>0,"Available","Not available")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Bob,

Thanks, that was what I was after I was almost there but was missing the
test value">0".

Thanks again to both of you for your patience. P
 
You can do it without that test using Boolean logic

=IF(COUNTIF(Sheet2!$A$1:$M$100,A1),"Available","Not available")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top