I must be getting something wrong!
I'm trying to set up a simple conditional format, such that a cell is green if its value is higher than another cell. I can get this to work if I type numbers into the 2 cells; it fails when I try the same thing on my data in situ!
The data I'm trying to use it on is copied from a 'background' sheet which, using a small VBA module, gets the data from a .csv file. The VBA uses the SPLIT function to separate the data into individual cells onto the background sheet.
I mention this because I'm suspicious that this may be causing the conditional formatting problem. If I type over the data which is subject to the conditional formatting with the numbers they display, it all works as I'd hoped!
Could somebody please tell me where I'm going wrong?!