Hi guys,
Forgive me if this is the wrong section..
I have a spreadsheet that does the following:
Cell A75 totals all of the cells above is (SUM) and displays this value.
This cell has conditional formatting so that if the cell is less than a certain value, it has a certain background/font colour, and if it is above a certain value, it has another background/font colour.
I would like for all cells above A75 (A74,A73 etc etc) to change to match the conditional formatted colour of Cell A75.
Is the possible?
To make matters more difficult, I have 18 rows that I need to do this too.
Many thanks for anybody who can point me in the right direction.
Bookmarks