Forum Discussion
Adding 1 to Every Number in Formula String
Hi All, I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are...
You may apply conditional formatting to the range $B$1:$AS$20 and into conditional formatting rule formula add condition ( MOD( ROW(),5 ) = 0 ).
Or like, entire picture is not clear.