Help with conditional formatting

New Contributor

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.

2 Replies


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.

@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