yogi_Conditionally Format Cell B4 For Specified Values Of B4/B2

Google Spreadsheet   Post  #2524

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-24-2018

question by: Remus1235
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/DeMmXpIvWc4;context-place=forum/docs

How to color a cell based on value percentage?

I have a table that shows:

row 1 the expected spending on a given period, 

row 2 the actual spending in an given period 

row 3 the remaining resources on a given period. 

I've managed to format the cell in row 3 to highlight by color if the amount reaches a certain value. (ex more than 50 is green, less than 50 or 0 is yellow and lower than 0 is red.)

is it possible to format the cell in that way that the color changes if the percentage of row 1 is reacded? (Ex more than 12% is green, between 12% and 0% is yellow and lower than o% is red).

Example