How to Track Progress with a Gradient Color Scale in Excel - using Conditional Formatting

[@tibibara]

I like the design and the idea as well, thanks!
But, just one important issue -> typing the numbers into the table area to trigger COFO-> NO WAY! - it's just not the real-life case.
I highly recommend to use an ID column as first column with a validation list to choose the ID quickly, and based on this column a dynamic formula can set the numbers automatically - I think, that's the a more advanced approach that I'd ask from my employee.
--------------------------------------------------------------------------
so for example as a staging table:
Process ID Process Step
JD Job Description
BR Budget Requested
BA Budget Approved
JA Job Advertised
IS Interviews Scheduled
IC Interviews Completed
JO Job Offered
CH Candidate Hired
--------------------------------------------------------------------------
And an example formula to make the table area dynamic:
>
HiringStatusStaging=LAMBDA([statusid],
LET(id, IF(ISOMITTED(statusid), "", statusid),
seq, IFS(
id = "JD", 1,
id = "BR", 2,
id = "BA", 3,
id = "JA", 4,
id = "IS", 5,
id = "IC", 6,
id = "JO", 7,
id = "CH", 8,
TRUE, ""),
status, IFERROR(SEQUENCE(, seq), ""),
status))
--------------------------------------------------------------------------

[@DataDesignStyle]

Thank you! And, thanks for sharing your idea - I like it! Your method would make the table easier to update and more dynamic. It's good to share ideas, so we can all help each other. 🙂 - Catherine