Multiple Functions ?

[Kyle4851]

I work for a security group that needs to monitor 3 different types o
licenses. I need to keep a track of the Expire date. I have
different cells that track the different licenses but i want to mak
one cell that will tell me if any of those 3 are false and turn th
cell red (besides using the Conditional Formating which is not a bi
deal). Could anyone help me below.

I have 3 cells that have these following formulas in them:

=D6-C1>31
=F6-C1>31
=H6-C1>3

 

[Norman Harker]

Hi Kyle4851!

For your master tracking cell, something like:

=IF(OR(D6-C1>31,F6-C1>31,H6-C1>31),"Expired","OK")
Or
If your three checks are in D1416
=SUMPRODUCT(--(D1416=TRUE))<>0

Use the conditions of the IF functions to create the conditions for
your conditional formatting. Or you use the return of FALSE as the
condition.

 

[Kyle4851]

That worked.. thanks alot.. saved me some money on Aspri

 

[Kyle4851]

It will work for one cell ( the first one that it reads), if the secon
cell is expired it does not change to that one? Any more ideas, i
would really help.


Thanks
Kyle
CR3 Security
www.cr3security.co

 

[Norman Harker]

Hi Kyle!

A little more detail on cells the formulas are in might help.

 

[Andy Wiggins]

=AND(D6-C1>31,F6-C1>31,H6-C1>31)

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"