Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Conditional Formatting
I have a problem with a spreadsheet Im doing, heres an example:
Cell A1 has a drop down list containing X & N/A When you select N/A from the drop down I want cell A1 and about 4 or 5 cells in the same row next to A1 to turn gray. I also want cells on the row below to turn gray How do I accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Conditional Formatting
See your other post
-- Biff Microsoft Excel MVP "BigDreams7433" wrote in message ... I have a problem with a spreadsheet Im doing, heres an example: Cell A1 has a drop down list containing X & N/A When you select N/A from the drop down I want cell A1 and about 4 or 5 cells in the same row next to A1 to turn gray. I also want cells on the row below to turn gray How do I accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |