I have two excel sheets

I have two excel sheets

I have two excel sheets

I have an excel conditional format which perfectly in a row. But for some reason when I copy to the row below it does not change the formula as I expected. I am using formula only rather than a standard paste and making sure the formula does not have an extra $ in it so it is not a static reference. See image of formula. I have tried many things but cannot see why this would not copy and change the formula when moving to different rows.

I have a worksheet with a large number of formulas in it. Each formula references another cell in another worksheet (ex. =HARASH!$U$16). I want to conditionally format each cell based on the cell value with three colour gradients (red, green, light green). D33 contains the value 1.25. If the cell is LESS THAN 5% of 1.25/D33, it should be red. If it EQUALS 5% of 1.25/D33, it should be light green. If it is GREATER THAN 1.25, it should be green.

I’m trying to do some tricky conditional formatting.

i’m trying to set up conditional formatting where a cell is highlighted if a date in Cell A1 is within 40 days of date in Cell A2. Any help appreciated!

I am trying to conditional format cells if they conatain a word NOT in a list.
I can get it to work if it is a single word but not if it is in a string.
I have tried
=NOT(ISNUMBER(–CONCAT(IFERROR(SEARCH(” “&$A$3:$A$5&” “,” “&C3&” “),””))))

I’ve inherited an Excel file and need to add some conditional formatting; which I never used, so this is all kind of new to me. This needs to be kind of dynamic since different users will have different number of rows on their spreadsheet.

sorry for asking, since this is a rather simple question.