| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Show a row shaded when a cell contains certain data
I have a spreadsheet which if column K has the data 'T2' in it I want the
whole row to be shaded red. Can anyone explain how to do this? Thanks Steve |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Show a row shaded when a cell contains certain data
Select the range that should be affected (A:Z???)
Then with the activecell in row #1 Format|conditional formatting Formula is: =$k1="T2" and give it a nice format Gadgetman wrote: I have a spreadsheet which if column K has the data 'T2' in it I want the whole row to be shaded red. Can anyone explain how to do this? Thanks Steve -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Show a row shaded when a cell contains certain data
Select column K
From the Format Menu, choose "Conditional Formatting..." Change "Cell Value Is" to "Formula Is" Enter the formula: =COUNTIF(K:K,"T2")0 Choose your format OK HTH, Elkar "Gadgetman" wrote: I have a spreadsheet which if column K has the data 'T2' in it I want the whole row to be shaded red. Can anyone explain how to do this? Thanks Steve |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Show a row shaded when a cell contains certain data
Thanks it did work but only in the K cell. What I need is for it to high the
whole row in the same shade. Thanks Steve "Elkar" wrote: Select column K From the Format Menu, choose "Conditional Formatting..." Change "Cell Value Is" to "Formula Is" Enter the formula: =COUNTIF(K:K,"T2")0 Choose your format OK HTH, Elkar "Gadgetman" wrote: I have a spreadsheet which if column K has the data 'T2' in it I want the whole row to be shaded red. Can anyone explain how to do this? Thanks Steve |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Show a row shaded when a cell contains certain data
Sorry Dave but you lost me. I tried it but it doesn't seem to work perhaps
if you could put it into idiots talk I may understand it a bit better. Thanks Steve "Dave Peterson" wrote: Select the range that should be affected (A:Z???) Then with the activecell in row #1 Format|conditional formatting Formula is: =$k1="T2" and give it a nice format Gadgetman wrote: I have a spreadsheet which if column K has the data 'T2' in it I want the whole row to be shaded red. Can anyone explain how to do this? Thanks Steve -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Show a row shaded when a cell contains certain data
Select all the columns you want formatted (select them all if you really meant
the entire row) Notice that there's one white cell in that selection. That's the activecell. Then follow those same instructions format|conditional formatting formula is =$k1="T2" and give it the format you want. I'm not sure this helps. But you may want to explain what you don't understand and what you did if it doesn't work. Gadgetman wrote: Sorry Dave but you lost me. I tried it but it doesn't seem to work perhaps if you could put it into idiots talk I may understand it a bit better. Thanks Steve "Dave Peterson" wrote: Select the range that should be affected (A:Z???) Then with the activecell in row #1 Format|conditional formatting Formula is: =$k1="T2" and give it a nice format Gadgetman wrote: I have a spreadsheet which if column K has the data 'T2' in it I want the whole row to be shaded red. Can anyone explain how to do this? Thanks Steve -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Show a row shaded when a cell contains certain data
Ps. Make sure that row 1 is visible when you do this--else the activecell may
not be row 1. Dave Peterson wrote: Select all the columns you want formatted (select them all if you really meant the entire row) Notice that there's one white cell in that selection. That's the activecell. Then follow those same instructions format|conditional formatting formula is =$k1="T2" and give it the format you want. I'm not sure this helps. But you may want to explain what you don't understand and what you did if it doesn't work. Gadgetman wrote: Sorry Dave but you lost me. I tried it but it doesn't seem to work perhaps if you could put it into idiots talk I may understand it a bit better. Thanks Steve "Dave Peterson" wrote: Select the range that should be affected (A:Z???) Then with the activecell in row #1 Format|conditional formatting Formula is: =$k1="T2" and give it a nice format Gadgetman wrote: I have a spreadsheet which if column K has the data 'T2' in it I want the whole row to be shaded red. Can anyone explain how to do this? Thanks Steve -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded cells won't print shaded | Excel Worksheet Functions | |||
| returning either a shaded cell &/or a text | Excel Discussion (Misc queries) | |||
| Need a shaded row in Excel that doesn't move as data changes | Excel Worksheet Functions | |||
| Shaded cells on a worksheet but do not show up on printed copy? | Excel Worksheet Functions | |||
| Need invisible/shaded/highlighted cell | Excel Discussion (Misc queries) | |||
Linear Mode
