Recent content by sveinhelge.urdal

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.