Highlight a row using conditional formatting in Excel

Пікірлер: 29

  • @dreashirlene3285
    @dreashirlene3285Ай бұрын

    So extremely helpful, short, sweet to the point. I love it.

  • @kurthannahs8490
    @kurthannahs84907 ай бұрын

    So helpful, been struggling with this for hours. I appreciate you.

  • @alirehman4041
    @alirehman40412 ай бұрын

    So Helpful. Thanks. Very video should be like this. Short and to the point

  • @bgcubingchannel9769
    @bgcubingchannel976910 ай бұрын

    I was searching for this "entire row color change" for like 3 days. Thank you!

  • @auntlynnie
    @auntlynnie7 ай бұрын

    This is AWESOME!

  • @jr5296
    @jr52967 ай бұрын

    Short and sweet. Thanks

  • @RandoVidz
    @RandoVidz10 ай бұрын

    If you add a row below the selected, will the function copy down to the new row?

  • @paballoulenda897
    @paballoulenda89725 күн бұрын

    Helped me ❤

  • @scottpeters1142
    @scottpeters114215 күн бұрын

    Double clicking F4 did not do anything, so I entered the formula manually to reflect yours. But mine does not change the color of the column or any cells

  • @itvset
    @itvset6 ай бұрын

    thank you... very very helful 🙏

  • @who-maytv3771
    @who-maytv37714 ай бұрын

    Thanks

  • @mrs_varon
    @mrs_varon7 ай бұрын

    Thank you!

  • @bingefeller
    @bingefeller26 күн бұрын

    thanks. how can i make this happen for a spreadsheet where the number of rows will increase daily? I currently have 1002 rows but this will rise each day.

  • @globalnation9474
    @globalnation94744 ай бұрын

    thankyou so much ❤❤❤❤❤❤

  • @anteklarin4964
    @anteklarin49649 ай бұрын

    thanks

  • @305dadecounty305
    @305dadecounty3058 ай бұрын

    Can you just put a drop down menu that allows you to pick complete, not started etc.

  • @fernandatorres3703
    @fernandatorres370311 ай бұрын

    😊😊😊😊

  • @Type-R-Gaming
    @Type-R-Gaming8 ай бұрын

    Thanks Man 👨

  • @charlin7231
    @charlin72317 ай бұрын

    Mine's not working, the row that was highlighed is the one above where I type the word Complete

  • @chkwkill

    @chkwkill

    6 ай бұрын

    Mine as well, any idea on how to fix it ?

  • @adrielsalazar8382
    @adrielsalazar83827 ай бұрын

    Parks and rec reference over here 😅

  • @calystah09
    @calystah093 ай бұрын

    This is great - but what if my answers vary? I have a common word "destroy" but it also includes the number of days that the item has been expired. So each cell is different and I can't get the whole row to highlight.

  • @sandymandyism
    @sandymandyismАй бұрын

    Duplicate rule not showing in excel

  • @JagannathY-fk6io
    @JagannathY-fk6io9 ай бұрын

    How can we apply the same conditional formatting automatically to the data that we add daily ?

  • @rubygiirll

    @rubygiirll

    6 ай бұрын

    I've been trying to figure that out and can't find any videos on it

  • @vanessaibarra2012

    @vanessaibarra2012

    5 ай бұрын

    did you figure out how to do it? im still trying to figure it out!@@rubygiirll

  • @marinoraven9598
    @marinoraven95982 ай бұрын

    not working

  • @sharonwilliams8552
    @sharonwilliams855210 ай бұрын

    Why does mine not look the same. When selecting new rule it doesn’t look like this

  • @enent2489

    @enent2489

    10 ай бұрын

    try opening on desktop version.