Forum Discussion
Formatting based on other cells
Hi jghaefka
You can do that through the conditional formatting, here are the steps:
Highlight C3 cell, then from Home tab--> in the Style group click on Conditional Formatting --> choose New Rule---> Use a formula to determine which cells to format --> write this formula =B3>=A3 then click on format --> open Fill tab --> pick the green color --> OK --> OK
This will format the C3 with the Green color if B3 is equal or greater than A3, to fill it with the Red color if B3 Less than A3, repeat the same step, just replace the formula with this on =B3<A3 then from the format choose the red color
Hi jghaefka
You can do that through the conditional formatting, here are the steps:
Highlight C3 cell, then from Home tab--> in the Style group click on Conditional Formatting --> choose New Rule---> Use a formula to determine which cells to format --> write this formula =B3>=A3 then click on format --> open Fill tab --> pick the green color --> OK --> OK
This will format the C3 with the Green color if B3 is equal or greater than A3, to fill it with the Red color if B3 Less than A3, repeat the same step, just replace the formula with this on =B3<A3 then from the format choose the red color
