Conditional Formatting - Using "is not blank"

[audiate]

Apologies if this has already been answered but searching through the posts takes a long time when people aren't descriptive with the subject line...

I want to conditionally format a cell based on the cell next to it being not blank.
I'm sure this should be easy but I couldn't find it in the Help anywhere..

thanks!

 

[Joe4]

Check to see is the length is greater than zero, i.e.
=LEN(C1)>0

 

[goblin]

In the conditional format dialog, select 'Formula is' in the drop down, and put use the following formula when formatting cell A1:

=isblank(A1)

Note that you can format ranges, if you are careful to to put reference the active cell in your formula. Thus if you select the range B3:C18 and C18 is the active cell (it is the one cell that is different in your selecion), your formula would be

=isblank(C18)

 

[audiate]

can I also use "isNOTblank" instead of "isblank"?

 

[Mark W.]

=NOT(ISBLANK(ref))

 

[Joe4]

It would be:

=NOT(ISBLANK(A1))

 

[audiate]

THANKS!!!

 

[Questionasker]

I have a similar problem, except that I also have conditional formatting to color band every other row. Problem is, the formula to recognize the non blank row is not working in the rows that have the color.
All I am trying to do is have the text in one cell change to bold when the other cell has any entry.
Any help?
Thank you!

 

[paramnesya]

I am attempting to format a cell ("Cell B") when another cell ("Cell A") is not blank. Using the =NOT(ISBLANK(*)) function is great.. However, Cell A contains an if-then formula, which determines if the cell is blank or not.

It seems like the ISBLANK function sees the formula, rather than the result of the formula, and returns the appropriate (in this case, undesired) ISBLANK result.

Does anyone know of a way around this? (In other words, a way for the ISBLANK function to choose based on the if-then's result, versus the if-then itself?)

I can provide further information (and an actual spreadsheet) if my explination is unclear.

Any help is greatly appreciated.

 

[valbobal]

I simply use an IF statement to make B1 blank (using "") if A1 is blank.

=IF(A1="","",formula to follow if there is a result in A1)

Works for me