1
vote
Accepted
Excel Conditional Formatting, alternating groups of three columns
If writing as few conditional formatting rules as possible is the goal, it is always possible to write supporting formulas in other cells in an unused part of the workbook, so that for any cell you ...
1
vote
Accepted
IF formula for conditional formatting
Create a formula rule.
In a conditional formatting formula rule, if the formula evaluates to TRUE, the formatting will be applied.
In your case, you create the rule with C17 selected and enter a ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
conditional-formatting × 840microsoft-excel × 660
worksheet-function × 180
microsoft-excel-2010 × 109
microsoft-excel-2007 × 59
microsoft-excel-2016 × 45
microsoft-excel-2013 × 44
vba × 40
formatting × 37
libreoffice-calc × 23
colors × 20
macros × 17
pivot-table × 16
spreadsheet × 16
cell-format × 16
google-spreadsheets × 14
microsoft-outlook × 13
highlighting × 13
libreoffice × 12
calendar × 12
microsoft-word × 8
openoffice-calc × 8
charts × 7
text-formatting × 7
vlookup × 7