Check of related records in a column have data filled in in the next colum
 

Hello,

Another question,

In Column A several identical data is registered.

Run all records of column A;
For each group of identical data in column A all fields related in column B should be filled in if at least one of them has filled data.
If there are empty ones (the others of the group have data in it), then those in column B should be marked with filled color red.


Clm.A Clm.B
aaa xx
aaa xx
aaa <- color field B3
aaa xx
bbb xx
bbb xx
ccc
ddd xx
ddd xx
ddd xx
eee
eee
fff xx
fff <- color field B14
fff <- color field B15
fff xx

Any help, Thanks!

regards, Johan

Check of related records in a column have data filled in in the next colum
 

Hi Johan,

Am Tue, 11 Oct 2016 20:28:08 -0700 (PDT) schrieb :

Run all records of column A;
For each group of identical data in column A all fields related in column B should be filled in if at least one of them has filled data.
If there are empty ones (the others of the group have data in it), then those in column B should be marked with filled color red.

Clm.A Clm.B
aaa xx
aaa xx
aaa <- color field B3
aaa xx
bbb xx
bbb xx
ccc
ddd xx
ddd xx
ddd xx
eee
eee
fff xx
fff <- color field B14
fff <- color field B15
fff xx

Select column B = Conditional Formatting = New Rule = Formula to
determine...
and insert following formula and format as expected:
=AND(SUMPRODUCT(--($A$1:$A$100=A1),--($B$1:$B$100<""))0,B1="")


Regards
Claus B.
--
Windows10
Office 2016