load data into array, check condition, and paste back into sheet

Hi all,

I want to check the condition of multiple cells in a range without creating a helper column (for convenience and to learn more about VBA).

In my sample file, column A will stay the same, but values in column B have to be adjusted based on my condition (cell in column B divided by cell in column A should not exceed 0.95). I created two helper columns to illustrate what I want to achieve. Column C uses the cell reference of column B to check for the condition, whereas column D uses the cell value of column B instead. I assume this could be done with code by loading the values of column B into an array, then checking if the condition is met and pasting it back into the range?