Forum Discussion
Conditional Formula?
I'm trying to make a conditional formula where if the logical test (=if(logical test) results in a number in another cell being greater the value of the formula cell returns a value with a color. Is ...
A formula can return a value, but it cannot directly change the cell color.
Use Conditional Formatting for the color.
Select the cell, then go to:
Home > Conditional Formatting > New Rule > Use a formula
For green:
=C1>B1
For red:
=C1<=B1
So the formula handles the value, and Conditional Formatting handles the color.