Is it possible to change a single cell or cell font color in a table? Conditional formatting will not work for me since conditional formatting applies to entire rows and not single cells. 

(e.g. cell one should be red if it is greater than 10, but cell two should be red if it's greater than 20. This is not possible when applying conditional formatting to a whole row. It would be easier to just change the cell colors one at a time.)

Alex,

Thank you for your reply.

Here is a link for the table in question I would want to create: https://docs.google.com/spreadsheets/d/e/2PACX-1vTjpLKfw3twTUMcsM7ALWiYnmetKKTeNDtoWmAdq8v3_usKD_RGEf-A7BujVbii5JiB4Nkp39Yi_hQs/pubhtml?gid=76880909&single=true

The far right column is the standard deviation of the current earnings yield compared to the historical average. Cells in red are standard deviations which are "negative" or "bad" (you might not want to invest right now). 

The problem is that these cells do not have anything in common that could be expressed in a column-based conditional formatting. A convenient solution would to mark "bad" or "negative" standard deviations in red using conditional formatting. Unfortunately standard deviations are always represented as positive numbers so the use of a conditional formatting with negative signs is not an options.

The ideal situation then would be if I could manually select cells to have red text/background. 

My understanding, however, is that manually selecting a cell for a specific color is not possible. Is this correct?

Bret

Aleksandar,

I first want to apologize for referring to you as "Alex" in my last reply. I don't know what I was thinking. 

While it is unfortunate to hear there is not currently a way to customize individual cells yet (though hopefully one day), I am excited to hear about the new table type.

I will  definitely get a subscription and  give it a go, and hopefully it will fulfill my needs, which I think it will.

Thank you for all your help!

Bret