How to select on 3000 and above in Amount column with same format , colours on same sheet

Help Studio
, ,
1

how to filter 3000 and above in Amount column with same format , colours on same sheet.
I tried with the filter data table but the format and colurs are not coming…any help please
sqdata.xlsx (9.4 KB)

expected result:
An Excel spreadsheet displays two columns labeled "transaction no" and "Amount," featuring transaction numbers in column A and corresponding amounts in column B, with the transaction numbers in red. (Captioned by AI)

2

HI,

Unfortunately, DataTable has no format information. So it’s necessary to copy format to filtered range. For now, can you try the following sample?

image
image1138×2154 162 KB

Sample
Sample20240822-1.zip (11.3 KB)
(Please check Result sheet in result.xlsx )

Regards,

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.