Download Excel Start File: people.highline.edu/mgirvin/Y...
Download file: people.highline.edu/mgirvin/E...
1. Create Logical Formula for Conditional Formatting to highlight the lowest smallest value in the row using the MIN function and Mixed Cell References.
2. Create Logical Formula for Conditional Formatting to highlight the largest biggest value in the row using the MIN function and Mixed Cell References.
3. See how to format top 3 values in a row using a Logical Formula and the LARGE function
4. See how to format bottom 3 values in a row using a Logical Formula and the SMALL function
5. Learn about how to create Mixed Cell References in formulas
Негізгі бет Ғылым және технология Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row
Пікірлер: 47