marcvanderpeet12
Member
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?
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?