| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row shading based on criteria
Hi,
I would like to have rows shaded only if a certain number on a row changes: So, if the data was like the following: 50772 JONE RON 355-FT-DR 50772 JONE RON 355-FT-DR 50772 JONE RON 355-FT-DR 50772 JONE RON 355-FT-DR 19780 ASSETT JAMES 25-FT-DR 19780 ASSETT JAMES 25-FT-DR 19780 ASSETT JAMES 25-FT-DR 19780 ASSETT JAMES 25-FT-DR 19780 ASSETT JAMES 25-FT-DR 100156 BEVIS SHAWN 25-FT-DR 100156 BEVIS SHAWN 25-FT-DR rows 1-4 and 10-11 would be shaded, skipping the rest. I have about 250 lines in total with this kind of arrangement. I have been reading about conditional formatting, and have some ideas, but not quite there yet! Any ideas? Thanks, Eric in FL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
| how can I use shading as criteria in a formula? | Excel Worksheet Functions | |||
| how do you set auto shading of cell based on percent value in exc. | Excel Worksheet Functions | |||
Threaded Mode
