Conditional formatting-Can I do a conditional formatting on a range

Can I do a conditional formatting on a range if the value
in one cell in the range = X

in other words can I format the back ground for line 5 if
C5 = X

You can format the backgrounnd of C5 if C5 = X, but I am not sure about the whole line, is that what you mean?

Use conditional formating.
Select the whole row
Set the condition Formula Is =$C$5="X"
Choose the Format you want for the cells in that row.

--
Regards
Roger Govier
"ESREI" <anonymous@discussions.microsoft.com> wrote in message
news:339b01c51f10$38d61860$a601280a@phx.gbl...
> Can I do a conditional formatting on a range if the value
> in one cell in the range = X
>
> in other words can I format the back ground for line 5 if
> C5 = X

1. Select your range.
2. Go to Format > Conditional Formatting
3. Select "Formula Is" and put:
=INDIRECT("rc",0)="x"
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Can I do a conditional formatting on a range if the
value
>in one cell in the range = X
>
>in other words can I format the back ground for line 5
if
>C5 = X
>.
>