View Single Post
 
Old 10-12-2013, 02:34 AM
secoo140 secoo140 is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Oct 2013
Posts: 11
secoo140 is on a distinguished road
Default Applying a conditional format to multiple rows

Hi
I am trying to apply a conditional format to 40 rows and infinite columns

Here is my code
F16:XFD16 apply red color higher than E16, apply green lower than C16

But the problem is
I try to apply this as only rising 16 to 17,18,19 but the conditional stay 16 all the time

I created same rule at the 17th row but this time it became 16-17-16-17
I need to make it like 16-17-18-19 by moving the cross on the left side.
Thanks
Reply With Quote