Excel Format Issue

Hi kvrose,

Thank you for posting your question in this community. Based on your description and screenshot you found that some cells is not highlight correctly in your workbook, which it highlight the cell above rather than the same row.

First of all, may I confirm the following information at your convenience?

1: How did you setup “highlight” row based on condition? Are you using the conditional formatting in Excel workbook?

2: As I noticed that you open the workbook in Excel for the web, have you tried to open the workbook in Excel desktop app and see whether the same scenario occurred, when you copy and paste the above rows?

3: Does this behavior occur in all the workbooks or this particular workbook? You can also try to create a new Excel workbook and see whether the same behavior occurs.

If the workbook is using conditional formatting in Excel, it seems that the conditional formatting setting caused this problem, you can check whether the conditional formatting is set up correctly for the rows you copy and paste, such as the range of the cells.

If it is convenient, it would be great if you can share a sample workbook with some dummy data via a sharing link below, so that we can check this behavior from our sides. Thank you.

Note: Please ensure there is no confidential or private information in your shared workbook.

Best regards,

Dihao

Hi kvrose, 

Regarding to this question, may I know is there any update? If so, please let us know below and share above information with us at your convenience.

Best regards,

Dihao

Hi Dihao,

Honestly the formatting was set up before I was hired so I'm not entirely sure how it was set up. I have tried opening the file in the desktop version and it still has the formatting issues.

Here's a link to a copy of the workbook 

https://1drv.ms/x/s!AianVBLTaYhceMHcae6hFA4XjCE?e=9wFkdG

the issue seems to have started in row 1543

Re,

"...Honestly the formatting was set up before I was hired so I'm not entirely sure how it was set up."

Hi

IMHO 

Whoever was hired before you did not complete the set of the Conditional Formatting rules for the sheet template

I noticed the same color (magnolia=light yellow) was used to highlight different conditions on the sheet

Me in your place, I would clear all the CF rules in the sheet(s) and start all over with my own set of CF rules.

It all depends on which cells you want to highlight and on what conditions,

I kindly suggest identifying the key columns the ones upon which the cell row must be highlighted in a sequential and prioritized manner

You may choose between highlighting the entire row or just the criteria cell depending on the priority.

Find in the link below a file with my approach as a solution to your problem

https://1drv.ms/x/s!AjGRD1TlwpAGnBSqDGMcZYm6tl9Q?e=IhT8dP

Notes:

1- I added an extra column with a formula to resume the "Status" for each listed person, based on the results in the "Position Offered" and "Position Accepted" key columns.

2- And set the CF rules according to the resulting value in the "Status" column.

3- On Dropdown List sheet

Do let me know if you need more help

On the other hand,

If the answer helped you.

Please, consider marking this thread as answered.

It would help others in the community with similar questions or problems.

Thank you in advance

Regards

Jeovany