| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting of one cell based on another using vba
Hello, I have a worksheet whos data comes from SQL Server db. Autofilter is
turned on. Within the worksheet are many columns. I would like to make change the backcolor of the cells in column C based on the content of the cell in column D on the same row (i.e. c1=5 d1='Pass' change backcolor of c1 to Green). There isn't a range of cells because the db gets updated more rows are added. How do I code this using vba? I would like to enter this in the sheet activate event. -- DC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting based on the value of another cell | Excel Discussion (Misc queries) | |||
| Conditional formatting, based on a different cell? | Excel Discussion (Misc queries) | |||
| Conditional formatting, based on a different cell? | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Threaded Mode
