Excel Magic Trick #153: Conditional Formatting for Incentive
6:50
Added: 3 years ago
From: ExcelIsFun
Views: 4,250
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (5)

Sign In or Sign Up now to post a comment!

  • 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 9 months ago

  • =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 9 months ago

  • amazingh

    gandukabacha 1 year ago

  • Cool - I am glad that you liked it!

    ExcelIsFun 1 year ago

  • Dear ExcelIsFun

    Thanks for doing these awesome videos

    keep up the good work

    sargondo 2 years ago

  • Dear sargondo,

    You are welcome!

    I'll keep making them!

    --excelisfun

    ExcelIsFun 2 years ago

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more