Good Afternoon,
I am working on a project as follows.
I have a excel sheet that has multiple columns with data. Focusing only on Columns("L:V" & lrow)
I want to loop through each cell in these columns with the following criteria
If Cell > 0 then highlight as green
If Cell < 0 then highlight as Red and make the text Bold and the font size equal to 14 (current default size is 11)
Each column is the same length always but that length does vary upon the data imported.
I appreciate the direction and assistance with this matter.
I want to solve this with VBA which will be used in part in other parts of this project and do not want to use the built in conditional formatting
Thank you.
I am working on a project as follows.
I have a excel sheet that has multiple columns with data. Focusing only on Columns("L:V" & lrow)
I want to loop through each cell in these columns with the following criteria
If Cell > 0 then highlight as green
If Cell < 0 then highlight as Red and make the text Bold and the font size equal to 14 (current default size is 11)
Each column is the same length always but that length does vary upon the data imported.
I appreciate the direction and assistance with this matter.
I want to solve this with VBA which will be used in part in other parts of this project and do not want to use the built in conditional formatting
Thank you.