# Formatting a cell based on multiple parameters

#### lhunt0194

##### New Member
Hello,

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,

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### ebea

##### Board Regular
If the essence of your explanation is, if U9 are above, or below 0.50, then just use conditional formatting in U9. It's easy set up!

#### lhunt0194

##### New Member
If the essence of your explanation is, if U9 are above, or below 0.50, then just use conditional formatting in U9. It's easy set up!
That’s the ultimate goal, but it’s getting the value for U9 first to compare it. 0.5 was just an example.

#### ebea

##### Board Regular
That’s the ultimate goal, but it’s getting the value for U9 first to compare it. 0.5 was just an example.
The amount are in reality not important; you can choose the Top and Bottom of the value. But set it up in Conditional Formatting. You can do it, without formula, in CF.

Replies
8
Views
125
Replies
12
Views
214
Replies
6
Views
176
Replies
5
Views
94
Replies
7
Views
130