I am looking to have a cell essentially put a in checkmark and green fill if a few conditions are met. It's a bit complicated so I will explain as best I can;

The cell I want the formula in is

**U:9**

The same sheet has 'important cells' B:9, I:9 and T:9

I have a list on a separate sheet (but in the same document) which has 3 columns (A, B, C) and 12 rows (1 - 12, 1st row are headers, rest are numerical values)

the set-up is:

- B:9 Will have one of the column headings from the separate sheet list (B:1 or C:1) manually put in

- I:9 Will have a numerical value from the 'A' column list (A:2 - A:12) manually put in

- T:9 Will have a calculated value in it from other cells

So for example lets say B:9 has 'heading1', I:9 has 150, and T:9 shows 0.50.

B:9 determines which column to check ('heading 1' is for column B), I:9 determines which row down on 'A' column (for example lets say 150 is on A:5, so it's looking for the value on B:5)

Then

**U:9**takes that value and compares it to the T:9 value ( in this example 0.50). If the value is greater than 0.5 it is 'wrong' (U:9 red fill), if it is less than 0.50 it is 'right' (U:9 green fill)

Hopefully that explains it clearly enough.

Regards,