Search results

Thanks. Problem Solved

I use the formula =A1<>A2 to highlight the last cell with same number using conditional formatting. It then highlights the cell with the last number in the series. How can I make it highlight the whole row? I have tried to Applies To the whole sheet, but then it check the last of the same info...

I have a list similar to this. (Have removed other columns with information that is not important for this question) CA-30003 CA-30003 CA-30003 CA-30003 CA-30004 CA-30004 CA-30004 CA-30004 CA-30005 CA-30005 CA-30005 CA-30005 What I'm trying to figure out is how to use...

Problem solved after a lot of trying...

I do not know any other way to explain.

Is this explanation better? A B C D E F G H I J Title Next due Forecast Received from Originator Sent to Checker Checker return Returned to Originator With Originator With Checker With Us Test 1 19.04.2024 15.04.2024 X here if D is not empty and E is empty Test 2 30.01.2024...

Sorry, I do not understand what youre asking.

That looks correct.

An explanation to wath I am thinking. Comments Cross in With Us shall be when it is received from originator but column E,F and G is empty. Or like in the nect row. Cross in with us if column F is not empty and G is impty. Cross in with originator if Column D is empty Crossin with...

I have a table like this: Title Next due Forecast Received from Originator Sent to Checker Checker return Returned to Originator With Originator With Checker With Us Comments Test 1 19.04.2024 15.04.2024 X Received by us but not expedited Test 2 30.01.2024 23.02.2024...

Super. That worked. Than ks.

I have a spreadsheet with a status column and a date column. Status can be 1 = Finished and 2 = Outstanding I'm looking for a way to highlight the row where the status is 2 and the date is overdue. It looks like this: Id Name Action Status Due Date 1 Peter 1 10.03.2024 2 Alex 2...

Solved. I found the solution myself.

Yes I seee that now. But I cant find a way to change it to start on zero.

I have a spreadsheet where I like to put in astacked bar. The chart shows Completed and Outstanding cases. I want it to show the number of completed to the left and Outstanding to the right. In that way the bar will grow to the right as the tasks will be complete. I have attached a sample...

This was really cool. Hov can I make this with the coding on a seperate Tab?

Thanks for the quick help. It works perfect.

I have a column A with four different status descriptions. I want to convert this in to a number for each code. Accepted = 1 Accepted with comments = 2 Not accepted, revise and resubmit = 3 For information only =4 I have tried this formula: '=IF(A2="Accepted";"1";IF(A2="Accepted with...

I have a spreadsheet with documents showing dates for planed issue, actually issued, rejected or approved. I want to create a chart showing the exact number of documents in each status on a timeline. I have attached an example file with a picture of a chart looking like the one I'm trying to...

Thanks. Worked perfect.

Can anyone help me create a conditional formatting based on two different conditions? I have a spreadsheet Where I have one column for Status and one for the date of reply. I have made some conditional formatting's that colors the row red if Status is 2, and green if status is 1 or 4. What I'm...

I have a report from an external system showing a long list of documents. List shows document numbers, title revision and so on. Looking like this Document Number Revision Issue reason Status Title 10003276804 1 Issued for CR 2 GENERAL ARRANGEMENT 10003276804 2 Re-issued CR 2 GENERAL...

Thanks!!!

I have uploaded the example file.