Hi All, i have used simple conditional formatiing to have a cell turn red if its contents do not match the contents of another target cell. I have used a second rule to turn the cell green when the cell does match the same target cell.
The problem I have is when i copy down the formatiing the cells automatically turn red because at this stage there is neither data in the target or formatted cell.
What i require is for the cell to stay its normal colour (white default) until I enter a number.
I have tried using a couple of =isblank formula but with no success. Perhaps the initial usage of conditional formatting was not a good choice.
any help appreciated
Bookmarks