Using Macro to change cell color based on reference cell value in different sheet

Hi there,

I have a problem with the Macro of my file that's quite urgent.
Please help me with this if you do know how to solve it.

I have two columns (say Column A & Column B) in sheet 1, and I need to display the value of Column B in my sheet to for reporting purpose. However, I need to color the cells (say value>1, red; value<1, green etc.) based on the repective value in Column A.
E.g. I need to display cells in Columns B on sheet1: B1,B2.....etc. as Column A on sheet2. And I want to color the column A on sheet 2 based on the value of Column A on sheet 1:A1,A2....etc.

Is there anyway to do it with Macro?


Thanks a lot.