| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code to Conditional Format a Cell Range
I have a spreadsheet that has text information entered from rows 1 to 10
and in clumns A to F. What is the code to look in column A, rows 1-10 for a text value, if found, shade the entire row from column A to F(Not just the cell). These cells will be reused on regular basis so I also need to have the code to remove the shading if text is blank and if text is not found. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format a range based on 1 cell | Excel Discussion (Misc queries) | |||
| conditional format of adjacent cell with different range and crite | New Users to Excel | |||
| Conditional Format for one cell based on range | Excel Worksheet Functions | |||
| Conditional format a cell based on another range of cells | Excel Worksheet Functions | |||
| Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
Threaded Mode
