Forum Discussion

Cansu_AKIN's avatar
Cansu_AKIN
Copper Contributor
Feb 19, 2022
Solved

highlighting a cell with min and max references

I am trying to highlight D1, if it is smaller than B1 or greater than C1. And how can I apply for the whole column? Can you help me?       
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 21, 2022

    Cansu_AKIN 

    It shall be

    =($D3<$B3)+($D3>$C3)

    not

    =($D$3<$B$3)+($D$3>$C$3)

Resources