Assume you want the range A1:E1 highlighted when cell E1= In.

Select the range A1:E1
Goto FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=$E1="In"

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"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