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

K

karldiffenderfer

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
 
B

Biff

Try this:

Select the range A4:I4
Goto Format>Conditional 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
 
K

karldiffenderfer

Perfecto!!!

Thanks!!!

Try this:

Select the range A4:I4
Goto Format>Conditional 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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Varying cell ranges in formulas according to number of cells with certain value 1
change cell color depending on two cell values 1
Cell Range Split into Multiple Cells 6
Highlight Cell Based Upon Referenced Cell Data 3
Conditional Formatting Formula 3
Test on the format of a cell in a formula ? 1
Searching based on text 7
conditional formatting based on relative cell value 2

Top