Apr 14 2021 12:33 PM
I'm trying to create a financial spreadsheet. I want to say, if my balance (B7) is >50% of my allocation (B5) I'm green, If my balance (B7) is between 30%-45% of my allocation (B5) I'm yellow. If my allocation (B7) is <30% of my allocation (B5) I'm red.
Apr 14 2021 01:10 PM
I assume that you want to format B7.
Select this cell.
Specify green as fill color (this will be the default).
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first dropdown set to 'Cell Value'.
Select 'less than or equal to' from the second dropdown.
Enter the formula =0.5*B5 in the box next to it.
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then click OK again.
Repeat these steps, but with the formula =0.3*B5 and red.
Apr 14 2021 01:40 PM
@Hans Vogelaar Thank you so much it worked - I even went the extra mile and did a value between!!!!!
I’m getting the power !!!! Thanks to this community