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
Conditional formatting
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional formatting
Are the 0s on the sheet where it doesn't work the result of a formula?
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Conditional formatting
Hello Hans,
Yes, on both tabs, the conditional formatting are place on a result of an array formula.
Thanks
Bitten Apple
Yes, on both tabs, the conditional formatting are place on a result of an array formula.
Thanks
Bitten Apple
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional formatting
Perhaps the result is not exactly 0. Could you attach a stripped-down copy of the workbook without sensitive info?
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12631
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Conditional formatting
It often helps to wrap these formulae in =ROUND(...,2) or similar, to lose any insignificant digits
StuartR