![]() |
please help in this program_2
put some values in column A:A. You can use
=-100+INT(RAND()*201) This will fill a column with random numbers from -100 to 100. VBA Task This one will be a teaser with If inside a loop. Make all the cells with negative values acquire red font. Make all positive cells with value less than 50 acquire blue font and those above 50 acquire a green font. In addition every 10 cells should have white background and alternate with another 10 cells with gray background PLEASE WRIGHT IT IN VBA |
All times are GMT +1. The time now is 03:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com