Conditional Formatting - Three Color for Balance v. Actual

Howdy! Hoping to get some help with a new project management sheet I am creating for a project we are working on in the architecture office. I am trying to use conditional formatting to notify a design if they are good, close, or over budget hours for each phase.

Column A has the different phases of design/construction.
Column B has the Budgeted Hours.
Column C has the Actual Hours.

I was trying to figure out how to either do a data bar or just a color gradient to fill the cell so they know they the status on the phase.
Green = Under Budget/Good | Yellow = At 75% of Budget Hours | Red = at 100% or more of the Budget Hours.

For example, if I put in anything from 0 to 58 in C4 it would be green since it is less than 75% of 78. It would turn yellow for any values between 59-77 and turn red for any values from 78 on up. And so on with the remained of the C column.

I was able to do the Green and Red easily, but I couldn't get the Yellow to work for the in between values of 75%-99%. I imagine I might need some if formula or something like that.

I attached a sample of the sheet I am creating. Thanks in advance for any help!

You can do solid colors with three formulas in conditional formatting, a formula for yellow would be =AND((C4/B4)>0.75,(C4/B4)<1.00) just click on new rule and there is an option to use formula

Im not sure if you can do a gradient that would change color though

Thank you so much for all the help!

I haven't used the AND function before and I didn't even think to highlight the entire row! Really appreciate the suggestions.

D

You are on the right path, you have to make three different conditions, First is for Green you said you have it working for that setting, So, just guessing you have the formula set to;

GREEN C4, AND((C4>B4*0.01),(C4<B4*0.5)) >1% to <50%
YELLOW C4, AND((C4>B4*0.5),(C4<B4*0.8)) >50% to <80%
RED C4, (C4>B4*0.8) >80%

Do the same to (C5,C6,C7 etc…N) Excel automatically puts a = sign and “ “ marks into the formulas. Remove them then click Apply button. You can copy and paste the formulas into each condition. You might also try highlighting the column while entering the formula into the top cell.