ExcelBanter - Conditional Formating Doesn't Work!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formating Doesn't Work! (https://www.excelbanter.com/excel-discussion-misc-queries/135585-conditional-formating-doesnt-work.html)

[email protected]

Conditional Formating Doesn't Work!

Can't figure out why this doesn't work!

Rule 1: if cell value = 0

Conditional Formating Doesn't Work!

It might be a rounding issue
try
equation is round(A1,0)=0
or whatever value you might want to round to.

" wrote:

Can't figure out why this doesn't work!

Rule 1: if cell value = 0

All times are GMT +1. The time now is 05:27 AM.