Hello,
I have some knowledge of VBA, but quit basics, so I need help with some coding.
I have a file in which I need to do formatting based on a specific formula.
Basically, I need to put a specific color, on each cell of some columns, based on the value of the cell in the next column.
If the value on cell B2 is less then 0, but the value on A2 is higher then 0, then is yellow, if value from both A2 and B2 are higher then 0 is green, if the value on both are less then 0 then is red. Cell values from column B are always less or equal to the cell values corresponding from column A.
I need to run this down for around 1500 rows, and lateral for around 60 columns.
Can somebody helps me with a code that repeats this formatting process both down through the rows, and lateral through the columns?
One additional issue is that this formatting is not starting from the top of the page, but from a position somewhere in the page(currently at cell U39).
I have some knowledge of VBA, but quit basics, so I need help with some coding.
I have a file in which I need to do formatting based on a specific formula.
Basically, I need to put a specific color, on each cell of some columns, based on the value of the cell in the next column.
If the value on cell B2 is less then 0, but the value on A2 is higher then 0, then is yellow, if value from both A2 and B2 are higher then 0 is green, if the value on both are less then 0 then is red. Cell values from column B are always less or equal to the cell values corresponding from column A.
I need to run this down for around 1500 rows, and lateral for around 60 columns.
Can somebody helps me with a code that repeats this formatting process both down through the rows, and lateral through the columns?
One additional issue is that this formatting is not starting from the top of the page, but from a position somewhere in the page(currently at cell U39).