Need help with conditional formatting formula!

[CollapsedSilence]

Hello,

New to the forums, but the knowledge here is amazing. Defintely will pop my head in and offer any advice I can to others.

I've been banging my head against a wall trying to find a way to make this work, and with no success..


I'm trying to have a formula in the empty column that will check my subtotal Net DR/CR's; if it nets 0.00, I want a X next to all the Bursar Batch #'s that are the same. If it does not net 0.00 I want a Y next to all the bursar batch #'s.

So for instance, since "16268 Total" nets 0.00, I want rows 2-5 to have an "X" in that blank colum. Since "16270 Total" nets to (4050.00) I want rows 8-9 to have a "Y" in the blank column.

Thanks in advance for trying to help, I appreciate any brainstorming people can come up with.

 

[CollapsedSilence]

Sorry for the delayed reply I was out of town. I got in this morning and have been playing around with the answers I got. I ran into a snag where the batch number getting pulled are being coded as text so it was throwing off Marmzz's formula. I found a quick workaround and got it working perfect.

Thanks everyone, I really appreciate your help.
These boards are great!

 

[markmzz]

Sorry for the delayed reply I was out of town. I got in this morning and have been playing around with the answers I got. I ran into a snag where the batch number getting pulled are being coded as text so it was throwing off Marmzz's formula. I found a quick workaround and got it working perfect.

Thanks everyone, I really appreciate your help.
These boards are great!

CollapsedSilence,

Ok, but you can try this:

=IF(ISERR(1*E$2:E$22),IF(ISERR(1*E$2:E$22)*(C$2:C$22=0),"X","Y"),F3)

Markmzz