Hi,

In 2007

1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=$A1="in"
5. Click the Format button and choose a format.
6. Click OK twice

Note that this works if A1 is the active cell of the highlighted range.
Suppose for example you want to highlight all of rows 1:20 based on the word
"in" in column B. then you would proceed as above but before you start
conditionally formatting you would press the Tab key to move the active cell
from A1 to B1 while maintaining the highlight. Then your formula would be
=$B1="in"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Kath" wrote in message
...
When using conditional formating is there any way to highlight an entire
row
when the criteria meets the cell format? My cell is = to "in" and that
cell
highlights when I type it but I would like the whole row to highlight. Or
is
there a way to use a cell format and ("and")?
--
Thanks much, Kath