ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   please help in this program_2 (https://www.excelbanter.com/excel-discussion-misc-queries/133268-please-help-program_2-a.html)

TheGodfather

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