| Home |
| Search |
| Today's Posts |
|
#3
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 |
| 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) | |||
Threaded Mode
