Conditional formatting

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Conditional formatting

Post by BittenApple »

Hello team,
I have conditional formatting and it is placed on the cells that shows the result of a function.
This works for a sheet but it doesn’t work in another sheet.
If the value of the cell is =0 then format the font white. This works in a tab but I set up same rule in another tab. This doesn’t work on the second tab. Any idea?

Thanks
Bittenapple

User avatar
HansV
Administrator
Posts: 78379
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional formatting

Post by HansV »

Are the 0s on the sheet where it doesn't work the result of a formula?
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Conditional formatting

Post by BittenApple »

Hello Hans,
Yes, on both tabs, the conditional formatting are place on a result of an array formula.
Thanks
Bitten Apple

User avatar
HansV
Administrator
Posts: 78379
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional formatting

Post by HansV »

Perhaps the result is not exactly 0. Could you attach a stripped-down copy of the workbook without sensitive info?
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12601
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Conditional formatting

Post by StuartR »

It often helps to wrap these formulae in =ROUND(...,2) or similar, to lose any insignificant digits
StuartR