Conditional Formatting Formula If. 2 highlight one cells based on another cell. The isodd function only returns true for odd numbers triggering the rule.
How to use excel conditional formatting with formulas. For example if the given argument is true then return this value else that value. One of the methods to achieve conditional formatting based on a custom formula is using the if statement.
Select the cells you want to format.
For example if the given argument is true then return this value else that value. 2 highlight one cells based on another cell. The if function works on the if then else condition syntax. E4 overdue click on the format button and select your desired formatting.
