CONDITIONAL FORMATTING

[Excel Enthusiast]

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]

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")))

 

[Excel Enthusiast]

Thank You So much GRAH-GUIDO. Actually i was trying the IF function but was not using multiple values. well thanks anyways.