Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Macro For Shading Rows - Or Should I Use Conditional Formatting?
I have a spreadsheet that I need to shade. Usually I do this manually,
but it's 3000 lines long, and doing this every time I run the report is extremely time consuming. Basically, the spreadsheet is listing the On Hand units and Sold Units for different styles of belts by sizes. It looks something like this: Style ID Size Total 8C0303 80 OH 0 8C0303 80 Sold 0 8C0303 80 OH 3 8C0303 80 Sold 0 8C0303 85 OH 0 8C0303 85 Sold 0 8C0303 85 OH 5 8C0303 85 Sold 2 8C0303 90 OH 0 8C0303 90 Sold 0 8C0303 95 OH 0 8C0303 95 Sold 0 8C0303 OH 8 8C0303 Sold 2 total oh 16 total sold 4 I would like to Shade all rows that show OH units so that the spreadsheet is easier to read. Any ideas? Thanks so much for your help! Best, Danielle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell shading with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
Conditional Formatting Shading For Visible Rows Only | Excel Discussion (Misc queries) | |||
Conditional formatting: alternate shading PLUS red for 0 values | Excel Discussion (Misc queries) | |||
conditional formatting-shading | Excel Worksheet Functions |