The Excel conditional formatting function is intended to offer the possibility of formatting cells depending on certain conditions. There are different types of rules that, if used correctly, make the formulas in Excel more productive. The time required for an evaluation can often be significantly reduced. The rule type "Use formula to determine the cells to be formatted" is particularly interesting. This enables meaningful evaluations to be created quickly.
Excel 2010: Apply conditional formatting
-
-
Thanks very much!!! It worked!
I looked for "formatting" for MAX and MIN values.
Formula is only to be replaced by MIN; but didn't know how to use both formulas for a "column" at the same time.
I then found out by trying it out under "Manage rule" - "New rule".Thank you Tom
-
Hello, thanks for the detailed description, it worked great! Such formulas really save a lot of time and trouble: P Here http://www.excel-helfer.de/excel-bedingte…von-werten.html I also found a useful video about it :)
Laura_____________________________
Modedit * Blue *
Link edited