Forum Discussion

oconnells's avatar
oconnells
Copper Contributor
Oct 08, 2019

Conditional formatting

Can someone please tell me where I am going wrong with my conditional formatting? I am trying to set it up so that a cell will turn red if the number input is less that the corresponding number in th...
Conditional Formatting
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Oct 08, 2019

Hi oconnells 

 

Conditional formatting in your file was linked (Freeze) to Column A only. I have modified it. Hopefully it will work as desired.

 

Please see the attached file.

 

Thanks

Tauqeer

oconnells's avatar
oconnells
Copper Contributor
Oct 08, 2019

tauqeeracma 

 

Hi, it still doesnt work. Any cells in columns B,C or D that contain a figure lower than the corresponding figure in column A should be red.

 

Jonathan

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Oct 08, 2019

    Hi Jonathan

     

    My apology, small issue in the formula

     

    please check it now.

     

    Thanks

    Tauqeer

     

Resources