COUNTIF on Summary Fields

  • Thread starter Thread starter DLC
  • Start date Start date
D

DLC

example: =COUNTIF($A$1:A$4,D2)=0

D2 contains G2+G3+G4

A1 through A4 contain 490, 500, 510, 520 which are numbers I want the
results to match after the sum of D2. If they don't match the number will
turn red.

















0
 
Did you ever check back to your original post on Conditional Formatting,
where I made a suggestion that would make this extra formula and list
unnecessary?

This link should take you back there:
http://tinyurl.com/7n9av

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top