Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing cell format based on word in first cell of row
I would like to understand how I can go through my workbook
looking at the word in the first cell of column A and change the cell format in that row to add a pattern, example In the "A" column I have one of three words it's either "Closed" "Open" or "Waiting" If its "Closed" I would like to select cells "A" through "H" on that row only and format those cells by changing the color to White If its "Open" I need to select those same cells and format then by changing the color to Green If its "Waiting", I would like to change those cells to Yello What I have been doing is sorting the sheet by the first column the manually selecting the rows and columns and formatting those cells with a right click, format cells, pattern then selecting the color based on the word in "A" column If this could happen automatically when ever this word is chnaged that would be great or even if I could just run a macro to run through the sheet and update row by row that would work as well TIA Jeff W. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for changing cell format based on more than 3 values | Excel Worksheet Functions | |||
Changing contents of cell based on Cell Format | Excel Worksheet Functions | |||
Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
Changing cell text color based on cell number | Excel Programming | |||
Changing cell text color based on cell number | Excel Programming |