• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.


Excel Enthusiast

New Member
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.
Thank You.
Pritpal Singh.


GraH - Guido

Well-Known Member
You don't need conditional formatting it seems.

2 ways to do, to show your text depending on value in other column.
- repeat the value via [L3]= IF(K3="","",K3), then apply custom format "CREDIT","DEBIT","CLEAR"
- or formula [L3] = IF(K3="","", IF (K3>0,"CREDIT",IF(K3<0,"DEBIT,"CLEAR")))