Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formatting cells in a row
My data consists of material in Column A, with properties of material from
Column B to column G. This goes on row by row as material is added. The material lies at 5 different places. I would like to colour code the row from Col A to Col H by different colour, depending upon where the material is stored. This helps in knowing by glancing, where most of material lies. Information about where material is kept, is entered in Column H against each item. Conditional formatting allows only three conditions, with fourth taken as default condition. can someone help using macro, to put five conditions in place? thanks harsh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count cells that meetin conditional formatting criteria | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) |