Excel highlighting row above the one it should be using with conditional formatting
this is what I am using=SEARCH($C$2,$A5&$B5&$C5&$D5)
looks like my screen is attached
any suggestions would great
thanks
Chuck
Excel highlighting row above the one it should be using with conditional formatting
this is what I am using=SEARCH($C$2,$A5&$B5&$C5&$D5)
looks like my screen is attached
any suggestions would great
thanks
Chuck
Welcome to the Forum Lswinnie!
A couple of bits of advice: 1) If you need to show us an image, attach the image inline instead of attaching another file with an image in it. Below your post, click Go Advanced. Place your cursor where you want the image to appear. Click the image icon pictureicon.jpg, then upload your image file. 2) Attach your Excel file instead of showing us a picture. It's easier to do, and we'll understand your problem a lot better (see yellow banner at the top of the page).
It is not possible to answer your question with certainty without seeing the "Applies To" range for your rule. However, based on what you have shown, I am betting it is A4:Hx where I can't even guess what x is. But your formula refers to row 5, so your Applies To range has to start in row 5. Change it to A5:Hx.
If that is not your problem then you need to attach your file, or at a minimum show a screen shot of the conditional formatting rules dialog box.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
thank you for the advice on posting images
I am new to excel so I'm not sure what Applies To is, but I will figure it out-if not I will attach my file
again thank you
Chuck
Applies To is the range that your conditional formatting rule applies to.
appliesto2.JPG
Last edited by 6StringJazzer; 09-09-2021 at 10:26 AM.
I'm sorry I think I'm still missing something
I have attached the file if someone would look at for me
Thanks
Chuck
The problem is exactly what I said. Your formula starts in row 5, but your Applies To range (the cells to be formatted) start in row 4. That means that Excel will format row 4 based on what it sees in row 5, will format row 5 based on what it sees in row 6, and so on.
wrongcf.JPG
I have corrected this in your file which is attached below the picture.
correctcf.JPG
it works great, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks