Hi, I have a spreadsheet with multiple sheets set up. Information that is entered on one overview sheet is then automatically pulled through onto multiple other sheets displaying different parts of the data.
I either need to find a way for the even the colour of a cell to be pulled through onto the other sheets as well as the data in the cell.....or alternatively I need to set up the cells on the other sheets with conditional formatting so they recognise the data being pulled through and the cell colour is formatted accordingly. However if I use this method I need to find a way to have more than 3 coditions on the conditional formatting of the cell.
Is there some way to do this using IF statements and a separate formula set up?
Any help would be appreciated....
Thanks
I either need to find a way for the even the colour of a cell to be pulled through onto the other sheets as well as the data in the cell.....or alternatively I need to set up the cells on the other sheets with conditional formatting so they recognise the data being pulled through and the cell colour is formatted accordingly. However if I use this method I need to find a way to have more than 3 coditions on the conditional formatting of the cell.
Is there some way to do this using IF statements and a separate formula set up?
Any help would be appreciated....
Thanks