Forum

Notifications
Clear all

Conditional formatting for cells

2 Posts
2 Users
0 Reactions
129 Views
(@mamoin)
Posts: 1
New Member
Topic starter
 

Does any one advic! how i will put  the below condition in work sheet.

If Dzn =12, if yds=36 & if pcs = 1

 

please some one help me

 
Posted : 29/07/2018 5:12 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Arif

I am assuming you want all the conditions to be true.

Try =AND(DNZ=12,YDS=36,PCS=1)

where DNZ, YDS and PCS are cell addresses.

You should attach a sample worksheet so that we can understand your question and requirement better.

Sunny

 
Posted : 30/07/2018 3:10 am
Share: