How to use conditional formatting with parameters

[marcvanderpeet12]

Dear all,

I have the following Excel sheet. In the tab "BE" there's an area that is using conditional formatting (fe, section C68: N78). I would like to try different ranges for conditional formatting. So ideally I want to be able to fill in data in the range Q68 to S 74 after which different formatting is applied.

The formatting works when I enter hard values like:





Buit if I enter parameters like



It does not seem to work. Any thoughts on how I can make the colour coding use parameters?

 

[p45cal]

Works here!
Attach a workbook with this not happening?

 

[Peter Bartholomew]

View attachment 84473

In principle, what you have done appears to be correct so it is a case of checking the details.
It does not seem to work. Any thoughts on how I can make the colour coding use parameters?