If Formula

[Ramesh_vm]

Hi..


I have the Trainig Sheet, in which i want use the " If Condition".


Name of the Staff Session Name Status Notes

Raj

Rakesh

Subodh

In D2 cell there should be formula with the option that if i select- "Attended" in cell C2 then In Notes section it should automaticall show "Completed" with the green Status or if not then Red with "Pending".

can someone help me with formula...

 

[vijay.vizzu]

You can use formula: =IF(C2="Attended","Completed","Pending")


By doing color: Conitional Formatting->New Rule->Format only cells that contains->click drop down-> select specific text-> containing->"Pend" again new rule for "Completed"


I hope it will work for you

 

[Ramesh_vm]

Thanks Vijay...


But In C2 the Attended and Pending is not showing(Its showing the Blank Cell). can you pls help me in this too..

 

[prazad82]

Hello,


I hope this helps


http://www.2shared.com/file/GfHRFDBx/Book1.html

 

[vijay.vizzu]

Dear Prazad82, i just modified your formula, =IF(C2="","",IF($C2="Attended","Completed","Pending")) to check blank or non blank cell in c column

 

[Ramesh_vm]

Thanks Prazad... Now Its working fine... Thanks For ur help...