Conditional Formatting Using If Formula. This formula can be copied down to row 12. Excel conditional formatting formula multiple conditions uses statements like less than or equal to or greater than or equal to the value are used in if formula syntax.
For example if the given argument is true then return this value else that value. Under select a rule type click the last option. Set formatting options and.
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.
Set formatting options and. The if function performs a logical test and returns one value for a true result and another for a false result. Choose new rule to open the new formatting rule dialog box. We can now create a custom formula within the conditional formatting rule to set the background color of all the overdue cells to red.
