2 last values with conditional formatting

ruiviagem

New Member
Joined
Apr 18, 2021
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
Hello everybody.
I need your help again !!!
Let's say that I need a conditional formatting for the (last two values) per line, when the last is less than 75% in relation to the penultimate.
I used 2 columns (maybe not even necessary, but I couldn't get better:) to give me the last two values when they are in my reference values (<= 75%) using the formula = IF ($ AG6 * 75% < = $ AH6; ""; 1).
I couldn't get better than the example in the photo.
Thank you in advance for a possible help.
Health for all
Help please....png
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,865
Office Version
  1. 365
Platform
  1. MacOS
you have also posted on another forum, always worth just mentioning that
Just that someone here may do a lot of work, only to find it was solved hours ago on the other forum
Are the Last 2 values always in the Same 2 columns ?
If so then you can use a simple conditional formatting formula
which is as posted
$ AH6 * 75% < = $ AG6
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,865
Office Version
  1. 365
Platform
  1. MacOS
Is this the expected result - i have used G & H instead of AG & AH for simplicity, for this i have also just as example added the formula in J & K , but not needed

cond-frmt-etaf.xlsx
ABCDEFGHIJK
1H * 75%H<=J
2$ AH6 * 75% < = $ AG610.50.375TRUE
3I have used H & G columns as an example232.25FALSE
4332.25TRUE
5464.5FALSE
654.93.675TRUE
Sheet1
Cell Formulas
RangeFormula
J2:J6J2=H2*0.75
K2:K6K2=J2<=G2
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:H6Expression=$H2*0.75<=$G2textNO
 
Last edited:
Solution

ruiviagem

New Member
Joined
Apr 18, 2021
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
Hi,
"Are the Last 2 values always in the Same 2 columns?"
No, the values are variable to the cell!
When I apply the formula (= IF ($ AG6 * 75% <= $ AH6; ""; 1)) it doesn't give me the desired result: ()
Thank you for your help
 

Attachments

  • Help please....png
    Help please....png
    65.9 KB · Views: 4

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,215
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: link in post#2
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 

ruiviagem

New Member
Joined
Apr 18, 2021
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: link in post#2
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
You are absolutely right.
Thanks
 

ruiviagem

New Member
Joined
Apr 18, 2021
Messages
8
Office Version
  1. 2019
Platform
  1. Windows
Is this the expected result - i have used G & H instead of AG & AH for simplicity, for this i have also just as example added the formula in J & K , but not needed

cond-frmt-etaf.xlsx
ABCDEFGHIJK
1H * 75%H<=J
2$ AH6 * 75% < = $ AG610.50.375TRUE
3I have used H & G columns as an example232.25FALSE
4332.25TRUE
5464.5FALSE
654.93.675TRUE
Sheet1
Cell Formulas
RangeFormula
J2:J6J2=H2*0.75
K2:K6K2=J2<=G2
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:H6Expression=$H2*0.75<=$G2textNO
Thanks
 

Forum statistics

Threads
1,140,993
Messages
5,703,611
Members
421,305
Latest member
ambuj Thakur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top