Forum Discussion
Formatting based on other cells
Hello team, I need help please. If possible; in cell C3 I want to format color fills, but I need it based off of cells A3 & B3. Specifically, if B3 is equal to or greater than A3 then C3 is green. Then for the other, if B3 is less than A3 less then C3 is red.
Thank you very much.
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
2 Replies
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
- Thank you so very much!! Works perfectly, thank you!
