Forum Discussion
Giving a colored cell a numerical value
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
These are just metrics, not sensitive information. But this is the dataset I was given and am working with.
For example, Lines 16-19 (four rows), one of the column will be colored based on today's patient volumes. In this example, I need B16=1, E17=4, E18=4, and B19=1, (because I need green=1, orange=2, yellow=3, red=4).
So then to tally the colored values, it should be 10.
As I type this, it sounds confusing, but basically I need the color to equal a numerical value, if that makes any sense.
Have B16, E17 etc. been colored manually or do you use conditional formatting rules to color them?
They are colored manually. Our units on the hospital floors report daily during our huddles, reason why it’s colored manually.
