|
|
#3
09-12-2019, 05:30 AM
|
|||
|
|||
Graham has provided a good solution, as usual.
Note that conditional formatting is far easier to achieve using Excel. You may want to use that for this part. 
|
| Tags |
| colour, formatting cells from vba, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional Formatting that highlights cells when there was a change in another column
|
Marcia | Excel | 4 | 04-28-2019 07:34 AM |
| How to fill a cell at row and column intersection with conditional Formatting | Iraj | Excel | 10 | 12-02-2017 09:54 AM |
| Conditional Formatting a column | Washbue1 | Excel | 3 | 01-27-2017 01:11 PM |
|
Conditional Formatting not expanding along with the table expanded
|
tinfanide | Excel | 3 | 10-07-2014 10:00 AM |
| Conditional Formatting: How to dynamically apply to an expanding table? | tinfanide | Excel | 0 | 10-18-2013 06:34 AM |
Windows 10 
Office 2016
Threaded Mode