| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shading row based on value in one of its columns
I have a spreadsheet and want to make it automatically shade any rows that
have the words NO BID in column D. Ive been trying to figure this out using conditional formatting, but have had no luck with higlighting ENTIRE ROWS. Please help. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shading row based on value in one of its columns
Highlight the rows desired at the row NUMBER on the left.At the first row in
selection if row 21 formula=$d21="NO BID"format as desired -- Don Guillett Microsoft MVP Excel SalesAid Software "EAPS" wrote in message ... I have a spreadsheet and want to make it automatically shade any rows that have the words NO BID in column D. Ive been trying to figure this out using conditional formatting, but have had no luck with higlighting ENTIRE ROWS. Please help. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shading based on change of values | Excel Discussion (Misc queries) | |||
| Shading Cells based on Date | Excel Worksheet Functions | |||
| Row shading based on criteria | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| how do you set auto shading of cell based on percent value in exc. | Excel Worksheet Functions | |||
Linear Mode
