Conditional Formatting with Multiple OR functions [closed]

Multi tool use
Multi tool use












1















I am looking to use conditional formatting to complete two or more functions. I want to use this OR() statement to format a cell that contains 0 OR n/a. Nothing too complex but for some reason I can't figure it out.



I've tried the following:
Conditional Formatting > New Rule > Use a formula...



Formatting function used is:



=AND(OR(A1=0,A1="n/a"),A1<>"")


I am expecting it to strike through and gray out anything with 0 or n/a.










share|improve this question















closed as off-topic by K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww Dec 30 '18 at 13:27


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on Super User." – K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww

If this question can be reworded to fit the rules in the help center, please edit the question.












  • 1





    Stack Overflow is for programming questions. Normal use of Excel - such as conditional formatting - should be asked on Super User.

    – K.Dᴀᴠɪs
    Dec 30 '18 at 8:02
















1















I am looking to use conditional formatting to complete two or more functions. I want to use this OR() statement to format a cell that contains 0 OR n/a. Nothing too complex but for some reason I can't figure it out.



I've tried the following:
Conditional Formatting > New Rule > Use a formula...



Formatting function used is:



=AND(OR(A1=0,A1="n/a"),A1<>"")


I am expecting it to strike through and gray out anything with 0 or n/a.










share|improve this question















closed as off-topic by K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww Dec 30 '18 at 13:27


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on Super User." – K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww

If this question can be reworded to fit the rules in the help center, please edit the question.












  • 1





    Stack Overflow is for programming questions. Normal use of Excel - such as conditional formatting - should be asked on Super User.

    – K.Dᴀᴠɪs
    Dec 30 '18 at 8:02














1












1








1








I am looking to use conditional formatting to complete two or more functions. I want to use this OR() statement to format a cell that contains 0 OR n/a. Nothing too complex but for some reason I can't figure it out.



I've tried the following:
Conditional Formatting > New Rule > Use a formula...



Formatting function used is:



=AND(OR(A1=0,A1="n/a"),A1<>"")


I am expecting it to strike through and gray out anything with 0 or n/a.










share|improve this question
















I am looking to use conditional formatting to complete two or more functions. I want to use this OR() statement to format a cell that contains 0 OR n/a. Nothing too complex but for some reason I can't figure it out.



I've tried the following:
Conditional Formatting > New Rule > Use a formula...



Formatting function used is:



=AND(OR(A1=0,A1="n/a"),A1<>"")


I am expecting it to strike through and gray out anything with 0 or n/a.







excel excel-formula conditional-formatting






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 2 at 16:11









pnuts

48.4k76297




48.4k76297










asked Dec 30 '18 at 0:18









Michael ChuteMichael Chute

61




61




closed as off-topic by K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww Dec 30 '18 at 13:27


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on Super User." – K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww

If this question can be reworded to fit the rules in the help center, please edit the question.







closed as off-topic by K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww Dec 30 '18 at 13:27


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions about general computing hardware and software are off-topic for Stack Overflow unless they directly involve tools used primarily for programming. You may be able to get help on Super User." – K.Dᴀᴠɪs, ekad, AdrianHHH, Vega, jww

If this question can be reworded to fit the rules in the help center, please edit the question.








  • 1





    Stack Overflow is for programming questions. Normal use of Excel - such as conditional formatting - should be asked on Super User.

    – K.Dᴀᴠɪs
    Dec 30 '18 at 8:02














  • 1





    Stack Overflow is for programming questions. Normal use of Excel - such as conditional formatting - should be asked on Super User.

    – K.Dᴀᴠɪs
    Dec 30 '18 at 8:02








1




1





Stack Overflow is for programming questions. Normal use of Excel - such as conditional formatting - should be asked on Super User.

– K.Dᴀᴠɪs
Dec 30 '18 at 8:02





Stack Overflow is for programming questions. Normal use of Excel - such as conditional formatting - should be asked on Super User.

– K.Dᴀᴠɪs
Dec 30 '18 at 8:02












0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

HGRiAv6gTgEI,pL HuT9ZzCC uRrVsaZ ldPH
QYp 9Y kQo NMKD0EIv,0KsM,Sf6Vk9

Popular posts from this blog

Monofisismo

Angular Downloading a file using contenturl with Basic Authentication

Olmecas