Hello all,

Thanks for stopping by. I applied conditional formatting to 20k+ rows using custom rules (formulas). The conditional formatting is applied but it does not work unless I retype the data in the cells. Does anyone know why this is happening? I have thousands of rows and I can't retype everything.

I tried copying and pasting the data back in the spreadsheet but that does not work.

Your assistance is appreciated!

Rey Krauss