If I add a confitional format to cell B3 which fills the cell an orange colour if B2 does not equal the same value. How do I copy and paste this format in to hundreds of rows below so that the conditional changes relatively, i.e. cell B4 fills orange if it does not equal cell B3 and so on...
The condition also needs to not fill orange if that cell is blank.
I know I will need to change the cell reference to not be absolute but I can not work out how to do this in excel 2007.
Example attached if that helps.
Thanks,
Adam.
Bookmarks