基于非空白的前一个单元格的条件格式 [英] Conditional format based on non-blank previous cell

问题描述

我需要根据先前的非空白单元格有条件地对单元格进行格式化

  ABCDEFG 
 AC BW IN 
 BW BC ST IN 
  

由于B1是AC，我希望C1和D1具有条件格式（更改后的填充将与B1中的格式匹配）。当我到达E1且值为BW时结束。在第2行上，我只想忽略b2，而只忽略格式d2。 SC。

当前，我有条件格式来查找列表，并且可以格式化单个单元格，但是我不明白如何在条件条件下创建事件的vlookup类型格式化公式字段，也不找到第一个非空白要检查的

编辑：添加了F和G列以表明我希望C1和D1进行格式化，但不F1或F2，仅是AC或BC之后的空白单元格。

解决方案

这是错误的方法。真正的问题是在这里以条件格式复制前一个单元格的格式，因为所需要做的就是从前一个单元格中复制格式。这种方式太复杂了。

I need to conditionally format cells in a row based on the prior non-blank cell

A    B    C    D    E    F    G
     AC             BW        IN
BW        BC        ST        IN

Because B1 is AC, i want C1 and D1 to have a conditional format (changed fill which will match the format in B1). That ends when i get to E1 and the value BW. On row 2 i want to ignore b2 and only format d2.

The values in that will turn the formatting on come from a list of values i.e. AC, BC, IC, SC.

currently i have conditional formatting that looks for the list and can format the individual cell but i don't understand how to create a vlookup type of event in the conditional formatting formula field, nor how to find the first non-blank to check

Edit: added the F and G columns to show that i want C1 and D1 to format but not F1 or F2, just the blank cells after the AC or BC.

解决方案

This is the wrong approach. The real question is here Copy format of previous cell in conditional formatting as all that is necessary is to copy the format from a previous cell. This way is too complex.

这篇关于基于非空白的前一个单元格的条件格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！