Conditional formatting across two data sets

Question

I have data sets with matching criteria. One with values already filled in- budget. One with no values yet- spend. I'd like to format the spend cells to automatically type in green font if the amount is less than or equal to the corresponding budget cell, and red if greater than. They're on the same sheet. I can do it for each cell but can't figure out how to do it over the whole area without having to do one by one.

Answer 1

Select B46:E77. B46 should be the active cell in the selection.

Set the font color to red. This will be the default.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than or equal to' from the second drop down.
In the box next to it, enter the formula

=B3

Click Format...
Activate the Font tab.
Select green as text color.
Click OK, then click OK again.

Answer 2

Select from B46 to E77, then use CF twice, both time using the formula option.

For the first, use the formula

=B46<=B3

and select the green font that you want as the format.

For the second, use the formula

=B46>B3

and select the red font that you want as the format.

Answer 3

Thank you!

Answer 4

Thank you!