drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 543
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance!!
My real table contains many columns but I only need to count the rows where A;B contains at least on cell blank
This table contains a conditional formatting to plot as yellow ifA or B is blank
I do not want to add a new column to this table to get the job done
My real table contains many columns but I only need to count the rows where A;B contains at least on cell blank
This table contains a conditional formatting to plot as yellow ifA or B is blank
I do not want to add a new column to this table to get the job done
Modelo 03.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | Table1 | Table name | ||||||
3 | ?? | Rows with at least on cell empty | ||||||
4 | ||||||||
5 | AA | BB | ||||||
6 | aaaaa | TRUE | =OR(A6="";B6="") | |||||
7 | ppppp | TRUE | =OR(A7="";B7="") | |||||
8 | sssss | jjjjj | FALSE | =OR(A8="";B8="") | ||||
9 | aaaaa | wwwww | FALSE | =OR(A9="";B9="") | ||||
10 | gggg | bbbb | FALSE | =OR(A10="";B10="") | ||||
11 | TRUE | =OR(A11="";B11="") | ||||||
12 | gggg | TRUE | =OR(A12="";B12="") | |||||
13 | TRUE | =OR(A13="";B13="") | ||||||
14 | rrrrr | uuuu | FALSE | =OR(A14="";B14="") | ||||
15 | ||||||||
16 | ||||||||
17 | ||||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D6:D14 | D6 | =OR(A6="",B6="") |
E6:E14 | E6 | =FORMULATEXT(D6) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A6:B14 | Expression | =OR($A6="";$B6="") | text | NO |