I am trying to highlight anomolies in my data and I have about 400 cells. I am concatinating 2 Access fields and exporting to Excel template. In the excel I want to highlight the cells with discripencies like any decimal -Neg should be highlighted at the same time any cell with 0-Pos should be highlighted.
I could implement 0-Pos conditional format which is stright forward. But how should I implement if there is a number -Neg like attached file.
Thanks in advance