Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am new to Excel and know a little, but I cant figure out conditional
formatting. Im doing a worksheet for my job and I need a group of cells in a row to change colors based on what is entered in a certain cell. For example: Cell A1 has a drop down list contatining X & N/A If N/A is selected from that list I want cell A1 and about 4 or 5 cells next to it on the same row to turn gray. This could also include not only the 4 or 5 cells next to A1 but possibly the row below that. Is this possible? If so, how do I do it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |