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

I need to develop a pop up menu that will present me selection options, and then based on my selections, scan through my spreadsheet and highlight the correct row. When I'm done with the row remove the highlighting and allow me to start the selection process over again, or allow me to input data into the spreadsheet.

Solved by I. B. in 22 mins

If something is going to happen tomorrow, highlight the row/cell yellow.
If something is going to happen within three days, highlight the cell green.
How do I sum the total payments for a given day?
How do I create a macro to re-configure the list to start at today's date
How do I create a formula that results in a 0 instead of #N/A?

Solved by G. S. in 11 mins

I have a conditional formatting that is =LEN($W$2:$W$24)<15 , what I'm trying to do is highlight those cells that have more than 15 characters which could be text or numbers. Help the formula above highlight in excel.

Solved by K. S. in 14 mins

I want the first 4 digits of column AC, AD and M to match. if not highlight all three cells in red if not matching. (note: first 4 digits only)

Solved by E. Q. in 12 mins

I cannot figure this step out and need help please.
Step 1: At this point, a smaller list of countries should be visible in the worksheet “Internet user and pop. Table”. Cross reference these countries with the list of tech ready countries in the “Tech Readiness 2016” and highlight in the “Internet user and pop. Table” worksheet the country or countries that are in both lists. You may choose any shade of orange as the highlighting color. Cross reference them using conditional formatting.

Solved by K. D. in 20 mins

I need to find a list of possible values within a sheet. For example I'm looking for the values of Dog, Cat, Snake anywhere within another sheet on that same workbook. Once found it, I want to learn how to highlight cells in excel for these cells.

Solved by G. W. in 21 mins

how to deletehighlight duplicates in excel, in a particular column after conditional formating,highlight cells,duplicate values process are then displayed for the 3 columns I have

Solved by F. S. in 26 mins

how to delete excel highlight duplicates from a single column of 3 columns after conditional formating>highlight cells>Duplicate Values have been selected and highlighted

Solved by C. H. in 30 mins

I have a spreadsheet that I have to print daily schedules from I have it conditional formatted so when I enter an X in the first cell of the row the row highlights. Through out that row there are X's in the cells of the daily sheet I must print from tabs at the bottom of the spreadsheet. So I have two questions:
Is there a formula that I can write so when I enter that X in the first cell it makes any other cell with an X in it print the corresponding bottom tabs daily schedule sheet. So looking at this I want the first X to say print sheet 3,8,12,15 from the tabs below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
x x x x x
tabs at bottom
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Or this would be my other option: Conditional formatting. My other question is on this same spreadsheet, Is there a formula that I can write so that when I enter that same X in that first cell I have conditional formatting that will highlight the X's in that row a color of my choice. I am thinking some kind of IF / THEN statement.

Solved by A. A. in 17 mins

Can you help fix the code in this sheet?
i have macro that should show highlight the difference between sheet1 and sheet2, on sheet 2 in red.
Using A as a lookup column i can figure out why it not finding changes to in the middle.
I need it to highlight changes A : AA
bu this is missing out F:X
Please help?? in anyway

Solved by D. D. in 25 mins