Formatting the color of a range of cells based on the value of one cell
 

I have a spreadsheet that I want to either "strikethrough" or gray out
text in cells based on whether there is an "x" in the one cell.

So for example.

Cells A4 to I4 have text and information in them. This information
when complete should show that it is complete. So when I put an "x" in
B4 I would like the whole line from A4 to I4 "gray out" or
"strikethrough" to signify that item is complete. If there is not an x
in the cell then I want the text in A4 to I4 to remain unchanged. I
tried conditional formatting but it didn't seem to do the trick.

Thanks in advance for any help you can offer.

-Karl

Formatting the color of a range of cells based on the value of one cell
 

Try this:

Select the range A4:I4
Goto FormatConditional Formatting
Formula Is: =$B4="x"
Click the Format button
Select the Font tab
Click the Color drop down
Click the lightest shade of gray for a "grayed out" appearance
OK out

Biff

wrote in message
oups.com...
I have a spreadsheet that I want to either "strikethrough" or gray out
text in cells based on whether there is an "x" in the one cell.

So for example.

Cells A4 to I4 have text and information in them. This information
when complete should show that it is complete. So when I put an "x" in
B4 I would like the whole line from A4 to I4 "gray out" or
"strikethrough" to signify that item is complete. If there is not an x
in the cell then I want the text in A4 to I4 to remain unchanged. I
tried conditional formatting but it didn't seem to do the trick.

Thanks in advance for any help you can offer.

-Karl

Formatting the color of a range of cells based on the value of one cell
 

Perfecto!!!

Thanks!!!


Biff wrote:
Try this:

Select the range A4:I4
Goto FormatConditional Formatting
Formula Is: =$B4="x"
Click the Format button
Select the Font tab
Click the Color drop down
Click the lightest shade of gray for a "grayed out" appearance
OK out

Biff

wrote in message
oups.com...
I have a spreadsheet that I want to either "strikethrough" or gray out
text in cells based on whether there is an "x" in the one cell.

So for example.

Cells A4 to I4 have text and information in them. This information
when complete should show that it is complete. So when I put an "x" in
B4 I would like the whole line from A4 to I4 "gray out" or
"strikethrough" to signify that item is complete. If there is not an x
in the cell then I want the text in A4 to I4 to remain unchanged. I
tried conditional formatting but it didn't seem to do the trick.

Thanks in advance for any help you can offer.

-Karl

Formatting the color of a range of cells based on the value of one cell
 

You're welcome. Thanks for the feedback!

Biff

wrote in message
oups.com...
Perfecto!!!

Thanks!!!


Biff wrote:
Try this:

Select the range A4:I4
Goto FormatConditional Formatting
Formula Is: =$B4="x"
Click the Format button
Select the Font tab
Click the Color drop down
Click the lightest shade of gray for a "grayed out" appearance
OK out

Biff

wrote in message
oups.com...
I have a spreadsheet that I want to either "strikethrough" or gray out
text in cells based on whether there is an "x" in the one cell.

So for example.

Cells A4 to I4 have text and information in them. This information
when complete should show that it is complete. So when I put an "x" in
B4 I would like the whole line from A4 to I4 "gray out" or
"strikethrough" to signify that item is complete. If there is not an x
in the cell then I want the text in A4 to I4 to remain unchanged. I
tried conditional formatting but it didn't seem to do the trick.

Thanks in advance for any help you can offer.

-Karl