Conditional format based on ISTEXT and ISBLANK values

[JDobbsy1987]

Hi,

I'm trying to create a conditional format that will highlight/format a row based on the following:
B2 has a value in & E2 is blank (i don't want the rule to apply if B2 has a value in but E2 does too)

Initially i had it set to highlight the row if B2 has a value inside it but it doesn't work too good as i also have conditional formatting set in E2 to highlight the row if it says "Yes" so the 2 formatting condition's were conflicting (if that makes sense )

I have attached the actual excel sheet if it helps.

Regards,
Jamie

[Moo the Dog]

I would think using the formula below as your Conditional Formatting test should work. Highlight the cells (row) you want affected and apply.

=and($b2<>"",$e2="")

- Moo

[JDobbsy1987]

I would think using the formula below as your Conditional Formatting test should work. Highlight the cells (row) you want affected and apply.

=and($b2<>"",$e2="")

- Moo

Thank you very much Moo, that worked perfectly!

Cheers,
Jamie

[Moo the Dog]

You're welcome, jamie. Glad I could help. And thanks for the rep.
- Moo