I have configured excel conditional formating as per in the picture and the cells are not highlighting as they should be. In this formating it should highlight four cells with red.
I then put " between the numbers and you can see in the 2nd picture cells are highlighting but the wrong cells? You can see 4.21 is highlighted?
I believe it has something to do with the 00.00 number format as I have no issues applying conditional formating to numbers with the format of 00 with no .
I have tried changing the cell format to text + number.
![mum8c57.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2Fmum8c57.png&hash=fe89ef6bd4cdfcd35944156e1a7b1cda)
I then put " between the numbers and you can see in the 2nd picture cells are highlighting but the wrong cells? You can see 4.21 is highlighted?
I believe it has something to do with the 00.00 number format as I have no issues applying conditional formating to numbers with the format of 00 with no .
I have tried changing the cell format to text + number.
![Ep8TmEY.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2FEp8TmEY.png&hash=aa49b756e27a446e0271f012d5abcd99)