Forum Discussion
Please help with formula
Hi everyone, I have a project plan spreadsheet that is color coded (Green, Yellow and Red) depending on the status of the task. I wrote a formula to auto calculate the overall project status bas...
The objective to achieve the color of Red, Green, and Yellow can also easily achieved by using conditional formatting. Just select the column for which color code on the basis of percentage and go to conditional formatting -> select rules -> Format cell that contains -> For cell value select in between of the value and set the percentage criteria and set the color you are looking for. Along with that, you can use user-defined color format to make any report look good.