Use conditional formatting to rotate the cell Red, Yellow, or Green depending on 3 values ​​on another sheet

Question

I have a table with 262 rows and 52 columns of data (numbers). I want to set each of the cells in the RAG format (red, amber, green) (possibly conditionally). The cell must refer to another sheet (new sheet) with three columns (A, B, C) and 262 rows. The formula for the three RAGs should look like this: -

if the value A100 <= column A, B, C100 (new sheet), then rotate the cell Green if the value A100 = or 10% more than the column A, B, C100 (new sheet), then rotate the cell Amber if the value A100 = or 20% more than column A, B, C100 (new sheet), then rotate cell Red

Answer 1

• Highlight the range of interest.
• On the Home tab, in the Styles group, click Conditional Formatting.
• Click Select Cell Rules

For the first rule

Click more, then in the Value field, select the cell criteria you want to be less than use the format drop-down list to select your color.

For the second,

Click less, then in the Value field, enter = = .9 *, and then click the cell criteria, then use the formatting just like step 1.

For the third,

Same as the second, except your formula = ". 8 *", not .9.