I am using Conditional Formatting with a formula to determine which cells to format. Is there a way to manipulate the actual formatting of the cells by formatting a referenced cell? For instance, I may use Cell A1 and apply borders, colour, font etc. to that cell and then I want this formatting to be used as the basis in my Conditional Formatting rule. If I change the formatting in Cell A1, then the Conditional Formatting rule updates and changes the formatting of the formula determined cells accordingly. Can anyone have a look at this, please?