Conditional Formatting Problem

[howard]

I have a value in C22. I would like to highlight the items in Red in F22:K22 using CF where the values are < than in C22


Your assistance in this regard is most appreciated

 

[mandukes]

Hi , I have noticed in some cell you used "," and in some you used "." Make it uniform otherwise it would not work.

Here is the amended code in excel.

https://drive.google.com/open?id=1YiN3UneyljDOt27bU0Dh-bKJklaHhAxb

 

[howard]

Thanks very much for sample file


Code now makes sense to me

 

[mandukes]

Your welcome!