What conditional formatting can’t do in a single rule is an IF/THEN/ELSE condition such as “If # is greater than 10 format red, else format green”. Any conditional formatting argument must generate a TRUE result, meaning that at a literal level, your conditional formatting rule is an If/Then statement along the lines of “If this condition is TRUE, THEN format the cell this way”. A question that often comes up among these “conditional formatting addicts” is Can I use If/Then formula to format a cell? If you are a fan of Excel’s conditional formatting feature, you probably find looking for even more and more ways to highlight useful information in your data. *Steps in this article will apply to Excel 2007-2016. By Tepring Crocker Categories: Conditional Formatting, Excel® Tags: If/Then Conditional formatting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |