Im making a report manualy today and i would like a vba to do it automaticly. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have want to have a conditional formatting on cells e8 to e35 to green if value over 77<o></o>
And another conditional formatting on cells f8 to f35 to green if over 90. <o></o>
<o> </o>
Seems fine enoght.. This is the reason why im posting here. <o></o>
<o> </o>
Format 1 if value in celle 8 to 35 is equal or over 77 set color green in cell. Its suppose to do this in colum e, h k and all the way to IO. So do one colum with format 1 ignore the next 2 colums, then do 1, ignore the next 2. Etc <o></o>
<o> </o>
Format 2 if value in celle 8 to 35 is equal or over 90 set color green in cell. Its suppose to do this in colum f, i l and all the way to IP. So do one colum with format 2 ignore the next to colums, then do 1, ignore the next to one. Etc <o></o>
<o> </o>
Cells in row 7 have value (in text) other then x and y, if you gonna use that please just write “xvalue” “xvalue” or something.<o></o>
<o> </o>
See pic it its still unclear. <o></o>
<o> </o>
http://img685.imageshack.us/i/mrexcel.png/<o></o>
<o> </o>
Thanks in advance<o></o>
<o> </o>
I have want to have a conditional formatting on cells e8 to e35 to green if value over 77<o></o>
And another conditional formatting on cells f8 to f35 to green if over 90. <o></o>
<o> </o>
Seems fine enoght.. This is the reason why im posting here. <o></o>
<o> </o>
Format 1 if value in celle 8 to 35 is equal or over 77 set color green in cell. Its suppose to do this in colum e, h k and all the way to IO. So do one colum with format 1 ignore the next 2 colums, then do 1, ignore the next 2. Etc <o></o>
<o> </o>
Format 2 if value in celle 8 to 35 is equal or over 90 set color green in cell. Its suppose to do this in colum f, i l and all the way to IP. So do one colum with format 2 ignore the next to colums, then do 1, ignore the next to one. Etc <o></o>
<o> </o>
Cells in row 7 have value (in text) other then x and y, if you gonna use that please just write “xvalue” “xvalue” or something.<o></o>
<o> </o>
See pic it its still unclear. <o></o>
<o> </o>
http://img685.imageshack.us/i/mrexcel.png/<o></o>
<o> </o>
Thanks in advance<o></o>