If you want to test only cell a1, the formula in the selected cells in
column B has to be: =$a$1=1 The formula $a1=1 will test a1, a2 a3 etc

Tyro

"bkunes" wrote in message
...
i selected all the data in my column B and then put in formula is =$a1=1
and
it doesnt work
--



"David Biddulph" wrote:

That sounds as if you haven't put the right formula in the right cell.
Look
again at your data and at your formula. What formula do you have in
which
cell?
--
David Biddulph

"bkunes" wrote in message
...
it highlights but not correct row

"David Biddulph" wrote:

In CF you don't want to use Cell Value Is, but instead you need
Formula
Is/
=$A1=1

Amend your cell reference as appropriate, but notice the *absolute*
reference for the column and *relative* address for the row. I have
assumed
that you are loking for a number 1, but if you want to look for the
text
string, change it to =$A1="1"
--
David Biddulph

"bkunes" wrote in message
...
this works for one cell but i want to highlight that cell and the
entire
row
that it is in

"yshridhar" wrote:

Using Conditional Format
Format/conditional format/ cell value = 1, selecting the format you
want.
best Wishes
Sreedhar

"bkunes" wrote:

i have done a search and if the data was a match i gave a "1" and
if
not a
"0". Now is there a way to highlight an entire row of
coresponding
data if
that one column ="1"
--