Get instant live Excel expert help to learn how to apply conditional formatting to a row

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire row should be changed in orange. Column E > conditional formatting > manage rules > New rule > Use a formula to determine which cells to format Formula =IF(NOT(ISBLANK(\$E2)),TRUE) Format = Bold orange color Applies to : =\$A\$2:\$F\$2 How to replicate it to the following rows? The formula does replicate but not the Applies to For row 3 I should get Formula =IF(NOT(ISBLANK(\$E3)),TRUE) Format = Bold orange color Applies to : =\$A\$3:\$F\$3 Thank you
Solved by I. A. in 12 mins
Automatticaly copy row from Sheet1 to another sheet if cell in certain column from Sheet1 has specific conditional formatting.
Solved by X. L. in 15 mins
I need a conditional formatting formula that highlights a selected row when a cell has any data in it. I have tried LEN(\$AF3)>" " What I need to track is when a value of \$0.00 or greater is entered, it colors a row. If I use just plain zero, even if the cell is empty, it colors the row. I don't want it to color fill unless there is data in the one cell
Solved by T. S. in 14 mins
I need to create conditional formatting that colors the row green if there is data in column E and red if column E is empty. It also has to be variable, since it will be varying in size
Solved by T. H. in 12 mins
-In column L, calculate the overall average grade for each student’s chapter assignments and exam. The overall average grade is the average of the contents in columns D through J. In Row 14 for each chapter and exam, create an AVERAGEIF function to calculate the average grade for those students who actually received a grade other than 0. Format both Row 14 and Column L to show one decimal. -In column M, calculate the final grade using a nested IF statement using the guidelines below: ------------ -Use conditional formatting in the final grade cell using light red fill with dark red text for any student earning an F. RULES ARE DOWNLOADED
Solved by M. U. in 24 mins
Greetings! I'm trying to copy the following conditional formatting formula to different cells, but I need the cell reference to change to reflect the cells where they're being pasted, ie. S16:T16, S17:T17, S18:T18, etc. I'm looking for a quicker way to input the formulas so that I don't have to put them in individually, as there are hundreds that need to be inputted. If you can assist, I would greatly appreciate it. Also, the point of this formula is to highlight the adjacent cells that have the same value. =COUNTIF(\$S\$15:\$T\$15,INDIRECT(ADDRESS(ROW(), COLUMN(), 4))) > 1
Solved by G. H. in 27 mins