Has anyone any guidance on how I can use Conditional formatting to do the following:

Compare a value in a cell to another cell and provide a red amber green fill based on being greater than, Equal to or lower than the cell it is compared to. I want to do this to a range of cells where the value may be different in each cell and is being compared to a different cell in eache instance (example below:

Reference cell –   3 4  5  3  5 3  4 

Value –                3 5  4  2  5  5  7

 Fill Colour –        A R G  G A R  R

The only was I have foud to do this so far is 3 conditional formatting formulas per cell (using formula for < = >) and I then cant copy all 3 rules to the other cells as the cell references are fixed ($B$3)

Thanks

​Has anyone any guidance on how I can use Conditional formatting to do the following: Compare a value in a cell to another cell and provide a red amber green fill based on being greater than, Equal to or lower than the cell it is compared to. I want to do this to a range of cells where the value may be different in each cell and is being compared to a different cell in eache instance (example below: Reference cell –   3 4  5  3  5 3  4 Value –                3 5  4  2  5  5  7 Fill Colour –        A R G  G A R  R The only was I have foud to do this so far is 3 conditional formatting formulas per cell (using formula for < = >) and I then cant copy all 3 rules to the other cells as the cell references are fixed ($B$3) Thanks   Read More

​