Conditional Formatting Using If Formula. And it has a very simple sense to work with formulas. Or a4 b2 a4 b2 60 if a4 is greater than b2 or a4 is less than b2 plus 60 days then format the cell otherwise do nothing.
For example if the given argument is true then return this value else that value. If formula returns true you ll get the formatting and if false then nothing. And a3 b2 a3 c2 if a3 is greater than b2 and a3 is less than c2 format the cell otherwise do nothing.
Under select a rule type click the last option.
The best part of conditional formatting is you can use formulas in it. Under select a rule type click the last option. This formula can be copied down to row 12. Set formatting options and.
