Using font color in formulas

**dufferjax** · 09-11-2012, 12:32 PM

Is it possible to use a font color as true value or false value in an "if" formula???

**Søren Larsen** · 09-11-2012, 12:39 PM

You can use "Conditional formatting", to change the font of a cell the value it displays. Perhaps that is what you need to do?

**dufferjax** · 09-11-2012, 01:06 PM

Thank you Soren. Conditional formatting works perfectly for a single cell. I was hoping to use same inputs in a formula which could be replicated over a large spread sheet. I have 12 columns of 20+ values which should fall between allowable limits. It would be nice to highlight the highs and lows in different colors. Otherwise it's just a hodgepodge of data to analyze cell by cell.

**Søren Larsen** · 09-11-2012, 01:12 PM

You can copy the conditional formatting of one cell to all your other cells in one go. Or am I missing the point?

**dufferjax** · 09-11-2012, 04:12 PM

Perhaps I am missing a point. When I try to copy the conditional format to other cells, I get the value of the original cell used to set the format.

Any other ideas gratefully accepted. Thanks again, Soren.

**Søren Larsen** · 09-11-2012, 04:14 PM

You can use "Paste special" and then choose "Validation"; then only the validation is pasted and not the contents. You can also select all the cells that you want to conditionally format, and then create the conditional formatting.