Hi all.
First time posting on a forum so apologies if I'm missing something.
I need to create a VBA formula that prompts the user if a cells value is greater then the value of the cell to the right of it.
As shown in the attachment, I have a predetermined table (cells with borders) with formulas that are filled based on an exported heat map on the left (no borders). The values in the "value gre" column is determined by the first value in each row of the heatmap that is greater then the value in the AVG*3 column. However there will be an issue if the value is greater then the value in the cell to the immediate right in the heat map. (for example, in row A 221 is in Value GRE, however in the heat map the next value (237) is less then 221).
I would like to prompt the user to check this table when this occurs, mentioning the cell that it occurs. This should happen for every instance that this occurs.
So far I have tried to select the value in "column # before" for each row, match the specific column # in the row, offset the cell to the appropriate row, and then see if the value in that cell is greater then the one to the right. Then prompt if it is, and the loop through for each row.
Does this sound like the proper idea for how the VBA code should be structured? I am still relatively new to VBA.. Please let me know if more info would be helpful!