How to Auto Highlight Row Based on Cell Value in Excel

preview_player
Показать описание
Learn automatically highlighting rows in excel based on the condition or value we put in cell. This we do by using conditional formatting.

Download the practice workbook from link below.
Workbook Number. 2

#excelformula #advanceexcel #exceltips
Рекомендации по теме
Комментарии
Автор

Great and to the point video. Thank you. You're one of the many unsung heroes of the internet.

charliecordell
Автор

i have applied the same but it is changing color of entire table rather than row.

AhsanKhan-ttet
Автор

Great video - it was exactly what I needed!!

ShellyGross-cr
Автор

This was so helpful, exactly what I was looking to do! Thank you so much!!! <333

PeachyKailey
Автор

Exactly what I was looking for, THANK YOU 🙏!

daenathedreamy
Автор

For some reason, whenever I do this, if I enter the specific word in the first row, in my case YES, it formats ALL the rows. But any other cell, other than the very first, it will only format that row as desired. How do I do this so that entering data into the first cell doesn't skew the rest?

grtvbol
Автор

Solved an immediate problem for me. Thanks.

runner
Автор

Thank you so much! I need this today! ❤

Victoria-pspz
Автор

thank you - learned something new. Now how do I write a script that for each row that has conditional highlight add remove in last column?

pinktrixmantha
Автор

Strange, to me this results in random coloring. The column with values to compare contains several different values.
The formula that woks for me in any case is =INDIRECT("G"&ROW())="Paid"

NReaver
Автор

Quick and to the point, not the 12 minute useless crap with bad music, thumbs up!! Is there a way to change the TEXT color for the entire row, as opposed to background?

RattlerSSBN
Автор

Great! What if we want to put date instead of word.

azimsaleh
Автор

How can I get to Show *VIEW CODE* when I Right Click on Tab
I don't get it when I Right Click on Tab :(
Please

iZacq
Автор

Instead of highlighting the row when you put words such as paid, how can you do it if it reads 100% so that it highlights the row? I tried the same method but doesn’t work.

christunches
Автор

I get an error message appears when I try as you've instructed. Any ideas or help?

samjermon
Автор

What if the cell value contains number

kalyaninavin
Автор

my entire table become same color after applying it ...

arunmohanan
Автор

it does not work for larger amount of data... useless

jenomspam