• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use conditional formatting with parameters

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:



Image 0622 110637.png

Buit if I enter parameters like

Image 0622 110627.png

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