Conditional Formatting – SmarterBusinessProcesses https://smarterbusinessprocesses.com Thu, 16 Apr 2015 10:52:03 +0000 en-US hourly 1 https://wordpress.org/?v=6.9 https://smarterbusinessprocesses.com/wp-content/uploads/2014/11/cropped-SBPm-Square-32x32.jpg Conditional Formatting – SmarterBusinessProcesses https://smarterbusinessprocesses.com 32 32 Tip: Using Conditional Formatting and Formulas Together https://smarterbusinessprocesses.com/tip-using-conditional-formatting-and-formulas-together/ Thu, 16 Apr 2015 10:52:03 +0000 https://smarterbusinessprocesses.com/?p=3531 Conditional formatting works great if you're looking to highlight rows based on data or values already contained in the sheet (e.g. a red background colour can appear on rows when the "status" is "overdue"). Issues can arise when you want to apply the formatting based on a comparison between two cells in the sheet. For example, if you have a "target cost" column and an "actual cost" column, and want to apply a red background colour to rows that exceed the estimate. This can't be done with conditional formatting rules alone.

That’s why we recommend using conditional formatting's greatest ally - formulas! Specifically, you will want to use an IF formula to perform the comparison between the two values, and then apply the formatting rule based on the result of the formula.

The post Tip: Using Conditional Formatting and Formulas Together appeared first on SmarterBusinessProcesses.

]]> The post Tip: Using Conditional Formatting and Formulas Together appeared first on SmarterBusinessProcesses.

]]>