How to use conditional formatting on multiple cells to change only the text colour

[DAVIETN]

Hi.
I’m trying to use conditional formatting to change ONLY the font colour in multiple cells.
I have a spreadsheet with multiple columns. Some columns formatted for date, others for currency, others for text, columns/cells with numbers use a monospaced font like Consolas, columns/cells with text use a proportional font like Arial.
I’m trying to create a conditional formula that well change ONLY the font colour of every cell in an entire row if a certain word is found in one of the cells on that row.
My condition works, but my problem is that the style I create (‘BlueText’) also overrides the other formatting attributes (date format, currency format, even the font name).

I created a new Style called ‘BlueText’ and set it to inherit from ‘Default’. Then the only setting I changed was in the ‘Font Effects’ section and I selected ‘Font Colour’ and set it to Blue.

But when apply that style to an entire row on my spreadsheet it changes all the other attributes, as well as the text colour. In a previously date formatted cell, the date format is lost and just displays a number. In a previously currency formatted cell, the currency symbol is lost and just displays the number. All cells in the row change to the same font name.
All I want to do is leave all other formatting unchanged, but change the colour of the text.

Is it possible to create a Style that leaves all other attributes unaffected but only changes the text colour? If so, how please?

Thanks.

[PKG]

I assume your default cell style contains a number format.
This could look like this, for example.

[DAVIETN]

Yes. Default style does contain font etc settings.
Is there a way to create a new style not based on any other Style so that it only affects the attributes I want (i.e. text colour) without setting others as well?
The “inherit from” box is a picklist. I can’t leave it blank when I create a new style.

[koyotak]

i think you need sub formattings of each formatting like text to text_blue and currency to currency_blue and numeral to numeral_blue with dominant and recessive styles.

[DAVIETN]

Thats what I was thinking - separate styles for blue_date, blue_currency, blue_text, blue_monospace - to replicate all the other cell formatting in each style, and then have multiple conditional format rules covering different cell ranges.
Its a bit messy though, which was why I was hoping I was doing something wrong.

Thanks

[PKG]

As I already wrote, it is possible that the default style contains a number format.

If you remove the number format from the default style, everything is ok again.

[DAVIETN]

This looks like it does what I’m after. How do I remove an attribute setting from a Style?
Or can I create a ''top" style that has no attributes, then I can only set what I want to change?

Thanks

[PKG]

[DAVIETN]

Hmmm … almost, but not quite.
I did as you suggested and clicked the Standard button on the Numbers tab of the Default style.
Then created a new ‘bluetext’ style inherit from ‘Default’ and select font colour blue on the Font Effects tab. However if I then apply this ‘bluetext’ Style to a cell thats been formatted to use Consolas as a monospaced font, it doesn’t mess up the date format, but it does change the font to whatever is specified in the ‘Default’ style.
I tried clicking the Standard button on the Default style Font tab but it won’t clear the font.

What I really need is to be able to create a new style that doesn’t inherit from anything, and then only change the attributes I want. So when I apply that style to any cell, it leaves all other formatting as it is and just applies what I want to change - in this case, only the font colour.

Thanks again.

[PKG]

If your document does not contain any confidential data, you could upload it.

[koyotak]

What’s possible in WRiTER – namely, generating a completely standard-independent format style – isn’t possible in CALC. Unfortunately!