trying to pull data based on %

  • Thread starter Thread starter Duri3l
  • Start date Start date
D

Duri3l

i have a three coulums, One total charge, item charge, and Total
payment.

I need to find out if the total payment was 50% of Total Charge or item
charge. I would like the formula to be able to highlight the total
payment if it is 50% of total charge.any one?

Thank you in advance for the help.
 
Duri3I,

Select the Total Payment Cell and choose Format -> Conditional
Formatting... In the first condition choose:
Cell Value Is equal to =0.5*$D$3 <-NOTE: you said you
wanted the cell highlighted if it is 50% if you want it highlighted if
it is greater than or equal to 50% use:
Cell Value Is greater than or equal to =0.5*$D$3

$D$3 would be the cell containing the Total Charge.

Choose a format for you condition and hit OK -> OK

You can add an additional condition for the Item charge vs. the
total payment.

Dan E
 
Duri3l said:
i have a three coulums, One total charge, item charge, and Total
payment.

I need to find out if the total payment was 50% of Total Charge or item
charge. I would like the formula to be able to highlight the total
payment if it is 50% of total charge.any one?
Click to expand...

You need Conditional Formatting on the Format menu. Assuming your columns
are A, B and C, the formula would be
=(C1/A1=0.5)
However, this would only trigger for EXACTLY 50%, so rounding errors may
make it fail. A better formula would be something like
=(ABS(2*C1-A1)<0.1)
 
format>conditional format>formula is>insert your fomula such as
=and(g8=.50*f8,g8=.50*e8)
format as desired.
 
Back
Top