highlight higher value

[Jagat Pavasia]

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)

I want Below :

I want that only 1 step big amount highlight.

can you help me which conditional formula used for it ?

 

[Cubist]

Highlight the range -> Determine format using formula.

=E6>$D6

 

[Jagat Pavasia]

Highlight the range -> Determine format using formula.

=E6>$D6

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

please help

 

[Cubist]

I want only first higher amount will highlight.

Try:

=E6=XLOOKUP(TRUE,$E6:$K6>$D6,$E6:$K6)

 

[Jagat Pavasia]

Try:

=E6=XLOOKUP(TRUE,$E6:$K6>$D6,$E6:$K6)

nothing do

 

[Jagat Pavasia]

Try:

=E6=XLOOKUP(TRUE,$E6:$K6>$D6,$E6:$K6)

=E6=XLOOKUP(TRUE,$E6:$U6>$D6,$E6:$U6)

working.....

thank YoUUUUUU

 

[Jagat Pavasia]

now, I want that my highlighted value, amount in Y6 to Y23 as from find out from E5 to U4

I want answer below ( I manually typed it)

Please help me to formula in Y6 to Y23

 

[Cubist]

Try:

=XLOOKUP(TRUE,E6:K6>D6,$E$5:$K$5)