Change Color of Entire Row when a cell is Blank/Not Blank | Conditional Formatting in Excel

Spent a good 30 minutes trying to find a video i needed… this was so simple its frustrating how easy this is… thank you!!!

thankyou. worked well !

Thank Yous

What if the new cf crosses over a cf already in place and over rides the cell with cf in place already?

does it work on specific text? and if yes then what would be the formula?

Thank u sir u are best

Perfect!!! Thank you!!! you save my day!!!

how about if i put words instead like "DONE ENCODING" then the row will fill color yellow on it. i'm starting to study excel formulas to make my job less hassle. thank you in advance.

Great tutorial, many thanks.

terima kasih, ini berhasil saya terapkan di google spreadsheet

Hey can you please help me, some cells are already highlighted but I'm struggling to highlight the whole row of the selective cells , can you please help me

i want to change colour if data not enter today , forexample today 30 if some one not enter data on 30th it should come red on 1st date and if today is 5 and my data entery opertor not put data on that day the cell should come red on 6th date that highlited me that he not do his work

This is definitely what I was looking for. Thank you!

In a comment below, you state that you've fixed the "blurriness" with the new videos. Can you please provide link to directions for: Highlight entire row when a cell is "not blank"? or please post the entire formula here. When I enter it, I receive an error that there is a problem with the formula.

My Objective:
-- Highlight entire rows when there is any value in a certain cell of a column

Thanks, I was looking for formula,

is the formula =$t2<>'' as its hard to see?

THank you.. For those of us who cannot see, are you type equals before you type the dolloar sign T? How do you type not equal? is it <> ?
Thanks to another comment, I got it. The format is
=($R5 ="Rain")

realy superb quick solution.

Not clear

Hi, this is fantastic, but I have a question that would be greatly appreciated if answered.

How do I change the color of the whole column (and not rows) when the entire column is filled??

Thanks! What formula can I use if I want to highlight the entire row if there is no data in all 4 cells of a row?

Can someone type out the formula I can’t see what he typed on the video

This was very helpful, but it was almost impossible to see the text you were typing in - and when I zoom it, it blurs.

@MITutorials hi sir, can you help me? I'm gonna make a ghant chart on my excel in a day to day basis but i want to make it more advanced, like for example i have a duration of 100 days from march 1 to june 8 , then i had a 2 suspended days in march (4 and 5). I want it to add on the last day of my duration then leave 2 days blank on the days that are suspended automatically? Is it possible?

I don’t see what you are typing.

is there any chances to contact you for similar doubt for this

i tried like this formatting formula. it works only work for input values, not working for calculated values.
example; I creat a dynamic excel sheet for future coming row in the sheet just in column A and B, at column C with function =if(B2=“”,””,A2/B2) then I format column C with formula =$C2>1, it format the cells of rows which is B2=“”.
actually i only want highlight with my format for inputted row, but pre-define format for upcoming row and don’t want to highlight column C for now with no input number in column A and B.
can you help me how to do this?
sorry for my complicated words.

whats the formular if a cell is blank then highlight the whole row?

By any chance do you have a tutorial about how to calculate costs based on dates I am struggling to fill up every month column costs when every person have different start and end dates. Thanks in advance

Can you please share the formula in the chat, I cannot see it in the screen. Many thanks