Multiple Functions ?

  • Thread starter Thread starter Kyle4851
  • Start date Start date
K

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
 
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 D14:D16
=SUMPRODUCT(--(D14:D16=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.
 
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
 
Back
Top