Excel Forumula

[MatthewL]

I have a conditional formatting rule that fills a cell with colour if below x number of characters which is below and does the job.

 

=LEN(J1)<7

 

I want to expand this now so it can look at column F and check if there is anything in there.

 

Result is that if column F is filled and column J is below 7 characters I want it to highlight. If F if empty I don't want it to in this instance.

 

Not sure how to get the IF F is not null sort of of thing.

[Seb1780]

Put in a seperate rule =f1=""

 

Run that rule first

 

Stop rules if condition met so the length rule does not run

[andy_b]

=AND(LEN(J1)<7,F1<>"")

[asteer]

The following formula should work, its currently designed as a formula that would go into a cell, and return a 1 or a 2, so might need a little change if used in conditional formating

 

=IF(AND(ISBLANK(F1),(LEN(J1))<7),1,2)

[MatthewL]

=AND(LEN(J1)<7,F1<>"")

 

Thanks, worked perfectly and what I needed. Cheers for that.