How to do conditional formatting with SORT function?

Question

HI,

I got this list that i sort. it has two columns, one column is names and on coulmn is numbers, and when the number in negative, the corresponding name turns red (together with the number that also turns red). This works when it is in a regular condition, but with SORT function it doesn't work that way, since the the info is changing. How can I make it happen?

thanks!

Answer 1

I made a workbook, it has four columns. A and B have conditional formatting (B is numbers and if they are negative then they turn red, and A has condition that say that if B1 is negative then A1 will be red), and then there is sort function, where the numbers column is conditioned same as column A, and the names column is the required column to be conditioned.

I uploaded to google drive:

https://docs.google.com/spreadsheets/d/1tDSy_LExC_c6qbunk6aVNtewAHWBq7D6/edit?usp=drivesdk&ouid=115837676641922622215&rtpof=true&sd=true

Answer 2

Could you share us a test workbook? Then I will have a try on it.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community