Combine Excel Formula PT2

Hello Experts,

I'm trying to compile a conditional format that states if two conditons are true then highlight a cell green.

The first condition would be if K2>H2 and second conditon (F2>C2,(F2-C2)>(D2-F2),(C2-E2)>(F2-C2)*1.5), then highlight cell green.

I wrote the following. Can someone please tell me if it will work:

=AND(K3>H3,F3>C3,(F3-C3)>(D3-F3),(C3-E3)>(F3-C3)*1.5)

Cheers

Carlton

cpatte7372Asked:
Who is Participating?
 
StephenJRConnect With a Mentor Commented:
Assuming your logic is correct, looks as if it should work.
0
 
StephenJRCommented:
Note that effectively you have four conditions.
0
 
cpatte7372Author Commented:
Hi Stephen,

What would you suggest mate?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
StephenJRCommented:
Carlton, I think it's ok. Have you tried it?
0
 
cpatte7372Author Commented:
Yeah, it works.

Ideally, I would like the results to be added to my existing log file.

In the attached I have certain conditions logged to a file called ABC.txt. I would like the results of this condition to also be logged to the txt file with time of the condition. Do you think you could help me with that?

Cheers
EE-NewCondition.xlsm
0
 
cpatte7372Author Commented:
Back in 15mins
0
 
ScriptAddictCommented:
What specifically do you want logged?  (although perhaps this is best as a separate question)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.