Conditional Formatting Issue

[sparky2205]

Hi folks,
this is a snip of part of my spreadsheet:
Production is from a drop down.
When "Not Scheduled" is selected from the drop down everything below that is filled in grey:

So this is my CF formula in C4;

All OK so far.
But I have to repeat this across and down so I thought; Formula: =C3="Not Scheduled" i.e. remove the absolute reference.
However, when I do this I get this:

Is there a simple way to achieve what I need?
Relative references don't work either.
The alternative is to keep the absolute reference and change it manually across the sheet. But that's a lot of manual.

 

[etaf]

what do you mean

But I have to repeat this across and down

you formula should work

formatting applies to C4 to E11
and tests for c3

 

[sparky2205]

This is what I mean by across and down:

This is just a sample. There are many more repetitions of the same basic unit both to the right and below.
So C3 to the right becomes F3, below becomes C12 and to the right and below becomes F12. This is why I wanted to remove the absolute references, so that I could just copy the CF to those other cells without having to alter the formula.