Multiple colors applied to one cell

I am pulling data from an Excel sheet listing resources. These resources (cells) are color-coded based on availability, training, etc. In a couple of instances, some resources might be available AND billable and, consequently, require 2 different colors in the cell (from the legend). In Excel, there is the ability to create a shading style (using two priimary colors) where it appears as both in the same cell. Is there any kind of function in SmartSheet that can produce the same effect? Or, for that matter, select a color that is not one of the 40 in the paint button?

Thanks so much!

Find more posts tagged with

Sheets

Comments

JLC

I myself would find this very useful especially in Calendar view - I currently only have one way of colour coding, which is just the background colour.

Pam - in your instance, in Grid view, perhaps you could apply a conditional format that affects the font colour? So you could have two colours - one in the background, and one for the font. Hope this helps!

Pam Tadsen

I was thinking something similar, based on selection of the checked boxes for availability, etc. The only issue I can see right now is that sometimes the planning is for several months out, with another project following (that has different availability criteria). So, while I can apply the conditional formatting, it applies to the whole row. I thought that perhaps an IF-THEN formula might work (if Box 1 checked, format cell color; when 2 boxes checked, apply the cell color for Box 1, then apply the font color for Box 2). I'm not even sure that makes sense, but I definitely think I'm at a formula point here...

I appreciate your input!

J. Craig Williams

Pam,

If you have the checkboxes, you could perhaps use conditional formatting on the cells only instead of the whole row. I've done this for "stripes" of columns that have related functionality.

Hope this helps.

Craig

Pam Tadsen

I'll try that, Craig - thanks!