Ringhal
04-17-2013, 04:00 AM
Hi everyone
I will attempt to explain what I want in this post. I have also attached a file with a better explanation.
I have two tables in a worksheet. One table lists all the tasks and the "status" of the task. In another table, I have listed the "status" with special formatting. I would like to, with the help of the VBAX community, color the tasks (first table) using the formatting in the second table ("status").
As an example, in the status table, it shows if a task has a status of 1, the task will be colored red, so, if the task has a status of 1 it must be colored red.
In the attached sample file, I have 2 sheets, a "before" and an "after" one. In sheet2, that's how I want it to look after the formatting/coding is done. All values in the sheet could change. Columns A to G are occupied by other data, irrelevent to what we're working with.
I will attempt to explain what I want in this post. I have also attached a file with a better explanation.
I have two tables in a worksheet. One table lists all the tasks and the "status" of the task. In another table, I have listed the "status" with special formatting. I would like to, with the help of the VBAX community, color the tasks (first table) using the formatting in the second table ("status").
As an example, in the status table, it shows if a task has a status of 1, the task will be colored red, so, if the task has a status of 1 it must be colored red.
In the attached sample file, I have 2 sheets, a "before" and an "after" one. In sheet2, that's how I want it to look after the formatting/coding is done. All values in the sheet could change. Columns A to G are occupied by other data, irrelevent to what we're working with.