Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting up formatting for a range of cells
Im close to getting this working (based on searching other topics).
I have a several rows of cells. If the entry in (lets say) D1 == "Do not do" then I want the other rows (A1..E1) to be formatted in a specific way (in this case with a strikethrough) ALSO I have a drop down list containing items (that come from a range). When a person selects an entyr from that list, id like to retain the formatting (color) from the range that list comes from. I could do it with the Conditional Formatting, but that only allows 3 options - in this case there are 5 entries in the list. Any help would be much appreciated! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Setting the magnification to a range of cell's | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |