Hey Luke, It works when I highlight the whole document. I was only
highlighting the row and for some reason it was highlighting the one after
it??? Not sure what to think of that. Anyways thanks again for the solution.
--
Thanks much, Kath


"Luke M" wrote:

Assuming cell you are concerned with is in column A

select entire row
condition format
formula is:
=$A1="in"

You could then copy this down to as many rows as you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kath" wrote:

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