Share via

Excel conditional formatting: Rule does not work

Anonymous
2017-10-23T13:36:59+00:00

Hi everybody,

as you can see on the screenshot attached, the conditional formatting should not apply to the cell highlighted as it is zero (and others). However it is applied in the conditional formatting. 

What might be a reason for that?

I will appreciate your help!

Thank you!

Best wishes,

Exceliser_123

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-10-23T15:40:19+00:00

    The values in the cells U6:Y9 are obtained from formula; the cells have been formatted to display integer values but the stored vales and not zero (see the first snip where the cells have been formatted with 4 decimals).

    I have used the formula in the Conditional Formatting dialog to get the required result:

    =ROUND(ABS(U6),0)>0

    See the second snip

    best wishes

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-10-23T14:29:35+00:00

    Hi,

    thank you for your reply. I have uploaded the Excel file here:

    https://1drv.ms/x/s!AtNwspiFU1pNgY98TVbFZRreVkZ0Og

    I hope that you can help me with my problem.

    Best wishes

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-10-23T14:17:36+00:00

    Can you upload a file to OneDrive or Dropbox and tell us the link?

    best wishes

    Was this answer helpful?

    0 comments