peterwmartin
03-29-2016, 11:38 AM
Hi All,
I have 5 columns d,e,f,g,h at any time only 2 are selected and the other 3 are hidden, I am trying to test if the cells on the same row are not = then change cells colour. Having problems getting my head around how to do it!
Have tried conditional formatting and recording a macro, yet I only seem to keep getting back to the same problems with the hidden columns. Can someone please give me some help or point me in the right direction.
Cheers
I have 5 columns d,e,f,g,h at any time only 2 are selected and the other 3 are hidden, I am trying to test if the cells on the same row are not = then change cells colour. Having problems getting my head around how to do it!
Have tried conditional formatting and recording a macro, yet I only seem to keep getting back to the same problems with the hidden columns. Can someone please give me some help or point me in the right direction.
Cheers