| Home |
| Search |
| Today's Posts |
|
#7
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 |
| 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
