I would like to use formulas and / or conditional formatting in my spread sheet to accomplish the following:
Doc is being used like a project plan where column A has tasks and sub tasks.
#1 I would like the main tasks (100/200/300 etc to be formatted all one color (light blue)). I would like the next level sub tasks (100.10, 100.20, 100.30, etc.) to all be colored a different color (say beige). and the remainder (220.14, 220.15, etc,)to be left as is. I know this can be done with conditional formatting on integers, but I have no idea how to achieve this.
#2 - see the HR Tab and Column E - I would like that column to be shaded Red if: D is not 100 and H is a date in the past. See cell E9 and advise if that is the best option? I would then like to really move it to infornt of A and have it be a flag for the row. Does that sound good?
And, if that is a good idea, can you tell me if I could create another Column in front of Column A that would read the data in Column A and do If if is a solid 100 - 200 - 300 Turn the whole Row blue and if it is 110, 120, 130 turn it beige but if it is NOT a whole number leave it alone? Is there a way to do that? If so can you please tell me how.
Feel free to add the formulas -or conditional formatting into the document.
Please help! And thank you all so very much. Excel is amazing but I have no education in it all.
Mod edit: Attachment removed at OP's request. Please see subsequent posts for an updated file
Doc is being used like a project plan where column A has tasks and sub tasks.
#1 I would like the main tasks (100/200/300 etc to be formatted all one color (light blue)). I would like the next level sub tasks (100.10, 100.20, 100.30, etc.) to all be colored a different color (say beige). and the remainder (220.14, 220.15, etc,)to be left as is. I know this can be done with conditional formatting on integers, but I have no idea how to achieve this.
#2 - see the HR Tab and Column E - I would like that column to be shaded Red if: D is not 100 and H is a date in the past. See cell E9 and advise if that is the best option? I would then like to really move it to infornt of A and have it be a flag for the row. Does that sound good?
And, if that is a good idea, can you tell me if I could create another Column in front of Column A that would read the data in Column A and do If if is a solid 100 - 200 - 300 Turn the whole Row blue and if it is 110, 120, 130 turn it beige but if it is NOT a whole number leave it alone? Is there a way to do that? If so can you please tell me how.
Feel free to add the formulas -or conditional formatting into the document.
Please help! And thank you all so very much. Excel is amazing but I have no education in it all.
Mod edit: Attachment removed at OP's request. Please see subsequent posts for an updated file
Last edited by a moderator: