Help Required for Conditional Formatting

[Khalid NGO]

Hello Everyone,
Greetings...

Once again need your help.
I tried to get N/A for the cells having 0 value, using CF: =(A1<1)


Further I need, it shows N/A too if cells are Blank (Range = A1:A5).
I tried my best to get but

Is there any way?

Sample file also attached.

Thank you,
Khalid

 

[Somendra Misra]

Hi Khalid,

You requirement is bit confusing; you want cells with 0 values as N/A???

Regards,

 

[Khalid NGO]

Hi Somendra,
Yes if cell = 0 (it show N/A) its working by using CF =(A1<1) Custom Format "N/A"

I need the same N/A if cell contains no value (blank)
I mean my empty cells should show "N/A" in the above range.

 

[Somendra Misra]

@Khalid NGO

I doubt that is possible through CF as it is like putting a default value in empty cell, and CF are not meant for that purpose.

Regards,

 

[Khalid NGO]

I dont have Minus values in my sheet

 

[Khalid NGO]

@Khalid NGO

I doubt that is possible through CF as it is like putting a default value in empty cell, and CF are not meant for that purpose.

Regards,

Oh:
Thanks Somendra, i will try to manage without N/A in my blank cells.
Thanks for explanation.