Can't change font colour when conditional formatting

**BelleVU** · 01-28-2019, 09:39 AM

Hi,

I'm trying to conditional format some cells so that change colour and be bold when the value is greater than zero. I can choose bold however I'm not able to choose a font colour. I can open the colour selector but when I press Red it goes back to Automatic. Please help, I'm sure I've done it before. Thanks

2019-01-28 13_37_03-Hot Tub Staff Hours_wc_20_Jan - Excel.png

2019-01-28 13_38_09-Hot Tub Staff Hours_wc_20_Jan - Excel.png

**rorya** · 01-28-2019, 10:02 AM

That should work, but you can actually do it the red colour with a simple custom cell number format. In the format cells dialog, set the number format to custom and enter:

[Red]0;-0;0

for example.

Can't change font colour when conditional formatting

LinkBack

Thread Tools

Rate This Thread

Display

Can't change font colour when conditional formatting

Re: Can't change font colour when conditional formatting

Thread Information

Users Browsing this Thread

Similar Threads

Coding to make tab colour change based on conditional formatting colour of cell range

Conditional Formatting - Change font colour based on whether cell contains formula or not

[SOLVED] Macro failing at conditional formatting font colour

[SOLVED] Conditional colour formatting without seeing the font used for the condition.

Conditional format formula need to change font colour

Conditional Formatting not changing font colour as required

Changle Font Colour of a Row using Conditional Formatting

Bookmarks

Bookmarks

Posting Permissions