Conditional Formating
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
|