VBA Formatting Problem

[VbaNoob1]

I'm new to VBA and I've been trying to piece together different codes to make this work, but I'm lost and could use some help.
The dataset goes from col A:X with unique numbers in the rows. Some rows are blank. I'd like to use code to evaluate each cell of each column. For example, if O3 enter image description here is < -.004 then change cell color to red else green. Each column has its own parameter, but I can figure that part out. I'd like help to create a VBA solution because each day I use a different file with the same format, but I use the same parameters to check all the cells. So I need a code to plug into the file everyday for automatic formatting.
Any help would be much appreciated!

 

[Yongle]

welcome to the forum

If every file is always in the same format then the formatting from a template can be applied to the daily file via VBA
- possibly as simple as copy & paste special format only

If the exact same rules can be applied every day then conditional formatting may be the simplest method to colour format each cell
- have you considered using conditional formatting ?

Have a look at this link
https://exceljet.net/conditional-formatting-with-formulas

CF rules can be set up at column level, row level, cell level etc
Multiple rules can be applied to the same range (sequence in which applied may be critical)
If you need help formulating CF conditions come back and with some more detail