Forum Discussion
Fcardoso66
Feb 22, 2024Copper Contributor
Logical Test with Formatting Return
I would like to confirm a logical test with the IF function to return a cell including color formatting as well
HansVogelaar
Feb 22, 2024MVP
A formula cannot set the color of a cell directly, but you can use the result of the formula in one or more conditional formatting rules (see Conditional Formatting