I've added a conditional format to a range of cells. It appear simple but its not working.
Basically, I've created a condition that states if values in column Q are equal to the values in column D then highlight cell blue.
As you'll see from the sample, in the first row I have D2 at 16.65 which is the same value as that of Q2, but the cell isn't highlighted.
Can someone explain why?