条件格式混乱的原因是什么？ [英] What is the cause for Conditional Formatting to get jumbled up?

问题描述

一段时间以来，我在使用条件格式设置时一直感到奇怪。我为公司中的另一个部门创建了一个Excel表格供使用，该表格具有以下条件格式的使用：

我问他们如何输入数据，他们说他们通常将其键入。我什至尝试复制/粘贴，拖放数据，但仍然无法复制其原因。虽然该功能仍然存在，但是如果我要编辑条件，到处都会感到头疼。

对于这个问题，看来

解决方案

已经提到了原因（移动，删除和插入）和解决方案非常简单：使用整个列范围。 （删除行，添加行或移动行都适合在整个列之内。）

现在，如果其中有值，则可能在前8行中出现问题那些可能触发您的CF规则的行。 （这不是经常发生的情况，因为许多CF规则与数字有关，并且通常标记行，通常很少是八行，通常是文本。）

您的公式规则为：

  = AND（......，ROW（）> 8）
  

篡改前八行仍然是一个问题，但似乎不太可能，并且有可能通过保护得到阻止。 p>

For a while now I've been having a strange oddity when using Conditional Formatting. I created an Excel sheet for a separate department in my company to use which has the use of conditional formatting as follows:

All neat and tidy. However, after a while when I check back the sheet at a later date, I find my formatting to be all over the place.

I asked them how they entered the data and they said they keyed it in normally. I even tried to copy/paste, drag and drop the data and I still can't replicate the cause of it. Granted the function is still there but if I want to edit the conditions it's going to be a major headache with it all over the place.

For this issue what seems to be the most likely cause and how can I prevent it?

解决方案

Causes have been mentioned (moves, deletions and insertions) and a solution is quite simple: use whole column ranges. (Deleting rows, adding rows or moving rows all fit within "whole column").

Now that might give you an issue in your first 8 rows if there are values in those rows that might trigger your CF rules. (This is not often the case as many CF rules are to do with numbers and often label rows, admittedly rarely as many as eight, are usually text.)

So wrap your formula rules in:

 =AND(......,ROW()>8)

Tampering with the first eight rows could still be an issue but seems less likely and could perhaps be prevented with protection.

这篇关于条件格式混乱的原因是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！