Applying if functions over conditional formatting

Hello, Formatting and functions are two different things. Having said that conditional formatting contains plenty of logics that can be incorporated in your formatting choices. Best,
Ned

whilst as Ned says, conditional formatting contains plenty of logics that can be incorporated in your formatting choices, it can be very tricky when starting with these to write custom formulas into conditional formatting rules, which I am guessing is what you are asking here? My advice is one, google a specific type of conditional formatting rule you wish to apply to see how it is done, there is usually someone somewhere who has done it before, or two, trial and error, by first writing the argument in a regular Excel cell and testing it, before then copying it into the conditional formatting rule. but even then, that isn't always straightforward. Hope that makes sense and hope it helps answer the question you were asking?