Conditionally format based nodata in 2cols but had text in another

[Casim]

Hi,

I'm trying to apply conditional format to any row that has textbin one column and no data in two others.

....................Col C.............Col J.........Col K
Row 1...........Text a............1...............1
row 2............Text b..............................
Row 3...........Text c.............2...............2
row 4............Text d...............................
Row 5............Text e............3...............3

So I want to conditionally format row 2 & 4 using the formula option.

Any help is very much appreciated.

Thanks,
Casim

 

[Marcelo Branco]

Hi and welcome,

Select C1:Kn (n = lastrow with data)

Home> Conditional Formatting> New Rule> Use a formula to determine which cells to format

insert this formula

=AND(ISTEXT($C1),$J1="",$K1="")

pick a format
ok, ok

HTH

M.

 

[Casim]

Thanks for your reply.
I'll try that and get back to you asap.

 

[Casim]

This worked perfectly, thank you