Search for answers to your questions by entering keywords below, or look through our knowledge base.
Welcome to 'Sikkhon' User Forum
Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users.
You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.
Blank cell count in less than 0 ms excel conditional formatting
Conditional formatting in MS Excel highlights blank cells, because it makes no difference between blank cells and 0. A blank cell equals a "0" value. So, when you create a conditional format for cells less than a certain number, like less than 50, Then blank cells get highlighted also. Because, empty cells equals a "0" value, for empty cells the condition is TRUE.
In that case you can set Two rules for that,
Create a new conditional formatting rule for the target cells by clicking Conditional formatting > New Rule >
1) less than 50 rule. if cell value has less then 50 the cell background color will be yellow.
2) Now set another rule, if cell value has less then 1, the cell background color will be white as like sheet background.
Fot that, you can use also ISBLANK function. But, be aware to use ISBLANK .
Use the ISBLANK function in conditional formatting formula when your cell truly a empty cells, i.e. cells that contain absolutely nothing: no spaces, no tabs, no carriage returns, no empty strings, etc.
For the below dataset, the formula is:
=ISBLANK(B3)=TRUE
Or simply:
=ISBLANK(B3)
That's how to use conditional format for blank cells in MS Excel.
Conditional formatting in MS Excel highlights blank cells, because it makes no difference between blank cells and 0. A blank cell equals a "0" value. So, when you create a conditional format for cells less than a certain number, like less than 50, Then blank cells get highlighted also. Because, empty cells equals a "0" value, for empty cells the condition is TRUE.
In that case you can set Two rules for that,
Create a new conditional formatting rule for the target cells by clicking Conditional formatting > New Rule >
Fot that, you can use also ISBLANK function. But, be aware to use ISBLANK .
Use the ISBLANK function in conditional formatting formula when your cell truly a empty cells, i.e. cells that contain absolutely nothing: no spaces, no tabs, no carriage returns, no empty strings, etc.
For the below dataset, the formula is:
=ISBLANK(B3)=TRUE
Or simply:
=ISBLANK(B3)
That's how to use conditional format for blank cells in MS Excel.
#sikkhon #msexcel
0 Votes
0 Comments
Login or Sign up to post a comment