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