So what ever conditions you used to color that cell you must use in the "IF" statement. If you just colored the cell using Formatting and their is no logical way to determin an algorithm, then no there is no formula way to do it. In this scenario we can use the Excel if Statement as: =IF(C2>=8000,C2*15%,C2*10%) In this formula, first of all we check if the salary of first employee (in C2 cell) is greater than or equal to 8000. If this is true then the formula evaluates an expression (C2 * 15%) otherwise the result should be calculated by the expression (C2 * 10%).

Aug 14, 2013 · I received an email from Bill this week asking how he can check if a range of cells contains text or numbers, as opposed to being empty.. We can use the ISTEXT function to test for text, and ISNUMBER function to test for numbers, but these only work on one cell at a time. Sep 19, 2019 · Fortunately, Excel offers some conditional formatting rules that can highlight cells or apply color scales to make your data stand out. (See example spreadsheet in the Resources section.) Article Contents. Feel free to jump ahead to any section in this Excel tutorial by clicking a link below.