Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting a cell with colour based on whether another cell's valu | Excel Worksheet Functions | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |