Excel Magic Trick #6: Conditional Formatting for a Row

Excel! See how to add Conditional Formatting to a whole row of data. See that the formula for this is a True/False formula. Then see how as you change the input, the conditional formatting magically updates!
See how to do this lightening fast with keyboard short cuts!

Category:

Science & Technology

Tags:

• Excel
• True
• False
• formula
• Conditional
• Formatting
• whole
• row
• of
• data
• shortcut
• mike
• gel
• Girvin
• highline
• community
• college

[Karin16121968]

Always interesting to look at your videos thanks so much for all the tricks you´re showing

[ExcelIsFun]

I am glad that it is interesting!

[Pelonetillo]

hi, excellsfun. what if i want to make the condition a text string instead of a number in a cell. how would i make the formula? im lost...

[ExcelIsFun]

I do not understand all the parameters to your question, but if you wanted to highlight a row when the word "rad' was in column A and your table was in the range A1:C10, this formula might work:

=$A1="Rad"

[Pelonetillo]

hi, sorry. basically, like in your example above, if instead of the condition being the number (200) in that cell, the row would be colored based on the customer being Google. i tried following the "Rad" example you posted and it didnt work. thanks!

[ExcelIsFun]

I do not know how to do what you are asking. This is the best site for asking Excel questions:

mrexcel[dot]com/forum

[bkleijer]

Thanx!

I was looking for this for a long time.

[ExcelIsFun]

I am glad that it was useful. Be sure to go to the excelisfun channel (Search YouTube for "excelisfun") and watch the video that automatically plays, which shows how to search for whatever video you may want (there are over 900 Excel how to videos).

[Pelonetillo]

thanks

[ExcelIsFun]

Yes - this is an old video (one of the first I ever made) over 2.5 years ago.

Small and blurry.

[aman1245singh]

For the first time I felt the font was a bit small. lol. But as always the video was fabulous : -) .

[ExcelIsFun]

I don'y know. I would try the whole thing over.