Howto set Cond Form for non-blank cell

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

How to set formula for condition format for cell that is non-blank e,g A1
 
Max said:
Try, as the cond format formula: =A1<>""
Click to expand...
....

Depends on how you're defining 'blank'. An alternative would be

=NOT(ISBLANK(A1))

or equivalently

=COUNTA(A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Conditional formatting formula for when 1 cell if blank _and_ another cell is not? 2
Populate cell with multiple non-blank text values 3
Conditional formatting based on formula cell 6
If B1 is not empty but B2 is ... conditional formatting "formula"? 2
Problem with ISBLANK Function 5
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
function for last non-blank entry in column? 2

Back
Top