Excel Magic Trick #153: Conditional Formatting for Incentive
Loading...
Loading...
7:40
Excel Magic Trick #154: Personal Budgets and VLOOKUPby ExcelIsFun5,710 views- 3:17
Excel Magic Trick #152: Extract records w Field Not Blankby ExcelIsFun3,677 views
- 10:26
Excel Magic Trick #150 Formatting Guidelines (Eye Candy)by ExcelIsFun8,667 views
- 10:50
Excel Magic Trick #203: SUMIF function formula 21 Examplesby ExcelIsFun45,608 views
- 4:13
Excel Magic Trick # 164: CEILING function in Price Formulaby ExcelIsFun3,258 views
- 7:36
Format cell alignment in Excelby bytebodger2,041 views
- 9:20
How to add subtract multiply and divide using Microsoft Excelby Jaymz28110,116 views
- 2:39
Excel Magic Trick #199: Histogram w Conditional Formattingby ExcelIsFun5,168 views
- 8:49
Excel Magic Trick # 161: Go To Tricks Complete Storyby ExcelIsFun8,170 views
- 6:50
Excel Magic Trick # 160: Find & Replace Format or Formulaby ExcelIsFun14,233 views
- 5:10
Excel Magic Trick #228: Text Formula & Forced Wrap Textby ExcelIsFun5,751 views
- 7:17
Excel Magic Trick #110: Partial Text Conditional Formattingby ExcelIsFun7,369 views
- 10:56
Excel Magic Trick #171: MACRO Data Validation from 3 listsby ExcelIsFun15,905 views
- 9:42
Excel Magic Trick #180: COUNTIF function formula 21 Examplesby ExcelIsFun34,381 views
- 7:12
Excel Magic Trick 163 Formula Return Descending Sorted Listby ExcelIsFun3,829 views
- 6:39
Excel Magic Trick #175: Count Between Upper & Lower Valueby ExcelIsFun4,902 views
- 9:18
Excel Magic Trick #200: 2007 Table Formula Nomenclatureby ExcelIsFun12,914 views
- 4:03
Excel Magic Trick #177: Data Validation Troubleby ExcelIsFun4,351 views
- 6:27
Excel Magic Trick #168: Cross Tabulation For a Surveyby ExcelIsFun16,499 views
- 2:34
YTLE#78: Conditional Format for Entire Tableby ExcelIsFun5,414 views
=MAX($C$15,$C$21,$C$28 delivers a number.
=C27=MAX($C$15,$C$21,$C$28) delivers a TRUE or FALSE.
To apply formatting you need a formula that says: "yes this cell is the max".
ExcelIsFun 8 months ago
one question:
why type =C27=MAX($C$15,$C$21,$C$28), instead of "=MAX($C$15,$C$21,$C$28)"? why need =C27=?
cheers
MrSeniorba 8 months ago
Cool - I am glad that you liked it!
ExcelIsFun 1 year ago
amazingh
gandukabacha 1 year ago
Dear sargondo,
You are welcome!
I'll keep making them!
--excelisfun
ExcelIsFun 2 years ago
Dear ExcelIsFun
Thanks for doing these awesome videos
keep up the good work
sargondo 2 years ago