I have a worksheet (A) containing a row of cells some of which contain data and some of which are blank. This row is conditionally formatted to colour fill the cells if they contain data.
I have another worksheet (B) which has an empty row of cells again conditionally formatted so that if they contain data they will colour fill. These cells are also custom formatted to ;;; so that it will hide any data that is input to the cell and leaving only the colour fill visible.
I want the data from the row in worksheet (A) to automatically be fed through to the row in worksheet (B). I have tried treating it as a named range and pulling it through but any blank cells in (A) are pulled through as 0 into (B) and therefore the cell fills with colour in sheet (B) when I wish it to remain uncoloured.
Please can someone advise how to resolve this.
Thank you
Bookmarks