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

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