Sir, I am making a salary sheet. In this i want conditional formating in column K and column L. If the amount in Column K is a negative amount then the text DEBIT should be automatically come in column L, and so on. I'm attaching a sample file. Please help and oblige.
18.6 KB Views: 2