Unconditional formatting Copying it across help
Hi Please can anyone help me on this.
See attached spreadsheet
On D339
I select the list and select the subject however, its proving very time consuming to copy the conditional formula across.
I want to select subjects and then it should change color of the below cells.
=COUNTIF(D$339,"Drama")>0
How can I change the formulea so it is easy to copy across to the other cells and the ones below?
Please help
|