highlight higher value

Jagat Pavasia

Active Member
Joined
Mar 9, 2015
Messages
411
Office Version
  1. 2021
Platform
  1. Windows
hi, sir

I want to highlight amount only that amount is bigger than in D6. (Highlight area selection from is E6 to U6)
same as D7 (Highlight area selection from is E7 to U7)
same as D8 (Highlight area selection from is E8 to U8)


12.JPG



I want Below :

34.JPG


I want that only 1 step big amount highlight.

can you help me which conditional formula used for it ?
 
Highlight the range -> Determine format using formula.
Excel Formula:
=E6>$D6
 
Upvote 0
Highlight the range -> Determine format using formula.
Excel Formula:
=E6>$D6
12.JPG



All higher value highlighted,
I want only first higher amount will highlight.
in above sample only amount "6595" should be highlighted.

please help
 
Upvote 0
now, I want that my highlighted value, amount in Y6 to Y23 as from find out from E5 to U4
12.JPG




I want answer below ( I manually typed it)

34.JPG



Please help me to formula in Y6 to Y23
 
Upvote 0
Try:
Excel Formula:
=XLOOKUP(TRUE,E6:K6>D6,$E$5:$K$5)
 
Upvote 0
Solution

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

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
Back
Top