Hello and nice to meet you all !
A good friend of mine recommended this website and suggested that here all the brightest and modest minds gather to help solve together all kinds of problems that we encounter in our daily excel based activities.
My Role : Junior PM
Excel Level : Basic
Excel Usage: Gant Charts
Excel Formula used : =IF(AND(K$3>=$E4,K$3<=$F4),"x","") - helps display with "x" the days that a task is being worked on.
Issue : I want to use conditional formatting to highlight (Green, Yellow, Gray, Red ) tasks that have the following status : Done / WIP / Not Started / Blocked.
Edit about usage: The scope would be to paste the formatting on all blue cells in order to automate the colors and "x" spots each time the tasks enter different status.
Task count: 50 - 100
Attached you will find the test sheet that I am working for, if you could also help me find a way to drag/use the formatting on multiple columns and rows that will be much appreciated.
Excel Issue.JPG
Best regards,
Razvan
Bookmarks