| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specific range formating
I have a sheet where I only want the code to effect certain parts of rows
(ie. D6:G6, D10:G10, D14:G14, etc). I want to apply conditional formatting. The CF function only allows 3 conditions, and I need 4 so I thought I would try it with VBA. I want to look at each of the cells in the specified ranges and if it's greater than 95, a certain color, between 90 and 95 another color, less than 90 a different color and if the cell has "N/A", to be black. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating Specific Text | Excel Discussion (Misc queries) | |||
| Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
| CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions | |||
| conditional formating a specific amount of cells in a row. | New Users to Excel | |||
| search a series of rows for a specific formating | Excel Worksheet Functions | |||
Threaded Mode
