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!

 

[Nelson461]

Jonmo1

Thank you...if I want this replicated for cells M4:O99 where the condition for each row must have three values...what is the adjustment?

Using your formula works great...if I input applies to =$M$4:$O$99 it wont work on line 9 if line 4 is not filled in yet

 

[Nelson461]

Thank you much!

What adjustment is needed to have this apply to all rows without a dependency on the prior rows being filled in? I.e...The user may fill out row 9 before row 4...the condition still must apply where all three columns must have LEN>0

 

[Nelson461]

Disregard...I found my error when I mis-copied your formula. You are my hero this morning!

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[J Helmore]

I also have a problem I have tried all of the above but to no avail. On my spread sheet I want to change the colour of the row when cell D2 has text in

 

[oldbrewer]

if D2 = $155

what then

 

[oldbrewer]

[TABLE="width: 199"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ghu[/TD]
[TD="align: right"]103[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]=code(A1) when A1 not blank returns the code for the first letter[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

so the conditional formatting formula in A! to Z1 would be

=code(A1)>0

 

[J Helmore]

it will be months in column D so when I type a month in the cell D2 the row will change colour

 

[Jonmo1]

Try
=$D2<>""