Get instant live Excel expert help to learn how to combine conditional formatting with IF statement
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi! I want my conditional formatting to only apply if a particular cell is filled in. How can I solve it?
Solved by K. F. in 19 mins
I have the conditional formatting set to A3=B3 then green, A3<>B3 then red. How can I copy that formula to the other cells and have the formula adjust to the new cell reference? i.e. I want A4=B4 then green, A4<>B4 then red and on down. I have tried the format painter but it keeps the original cell reference even if I remove the $ signs. Thank you.
Solved by V. U. in 18 mins
Hello, I need help with conditional formatting. My issue: I have a delivery schedule that I need to track. If the order is created between 00:41 and 01:40, delivery time must be by 02:55. If the order time is between 01:41 and 02:40, delivery time must be by 03:55, and so on throughout the day 24hr. I need help creating a format that will highlight anything delivered past its scheduled time . Thanks.
Solved by B. J. in 29 mins
I need to use conditional formatting so if a value of Y is entered in to a cell i can have multiple cells turn green
Solved by E. L. in 25 mins
Use conditional formatting so that if an OPPORTUNITY_STATE is "Won" than it turns the background green, "Lost" or "Abandoned" it turns red and "Open" it turns blue
Solved by B. J. in 21 mins
I'm working on an Excel spreadsheet with 7 columns. If there is a DATE in column 5, I'm wanting the whole line formatted with strikethrough. How do I do this under conditional formatting? Or, is there another way?
Solved by T. H. in 12 mins
Sorry I'm an absolute noob in Excel, and actually need help with conditional formatting in Google sheets.I know it's not even half as good as Excel, but that's all I got to work with. I need to create conditional formatting:
if the currency value in column B row 12 equals the currency value in column F row 12 then make the cells in columns A and B row 13 should turn green.
I also want to ensure that should the rows change (i.e. I add or remove a row) the formula will still work.
Solved by S. B. in 16 mins
My conditional formatting is not showing up right away. If I scroll the field with conditional formatting off the page and then scroll back to it, the conditional formatting will work. What is causing this to happen? It was working fine yesterday.
Solved by F. A. in 11 mins
Forms are sent to hundreds of TV stations for our clients. We must use ".xls" files because about half can't open ".xlsx" files. When completed and returned about half are "xlsx" files and half still "xls" formats. But occasionally we will get back ".xlsx" files that have errors inducted in conditional formatting or validation settings. I know that if you open them in Numbers or good docs, the files won't work. But I know know why some, no nearly all, will return with formating or validation errors. I can supply a file with the errors and the original that was sent.
Solved by M. W. in 12 mins
I need help with conditional formatting. Essentially... If C8 contains the word MRI, it must contain one of the words in range A4:A9, otherwise the cell turns red.
This is what I have so far but it doesn't work:
=SUMPRODUCT(--ISNUMBER(SEARCH("MRI"&Sheet4!A4:A9,$C$8)))>0
Solved by Z. H. in 23 mins