|The only thing a Conditional Formatting rule needs to format a cell is a formula that returns TRUE.|
Test your formulas in a cell and when you find one that returns TRUE for the conditions you need, use it as a Conditional Formatting rule.
Give us some examples of your conditions and we'll see if we can help.
BTW...most Excels users have been taught to use IF statements in Conditional Formatting. You don't always have to.
For example, when comparing A1 to B1, many users will use:
=IF(A1>B1, TRUE, FALSE)
All that is really needed is:
This will return TRUE when A1 > B1 and the Conditional Formatting will be applied.
Try =A1>B1 in a cell and see what it returns.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.