Conditional formating for table row if one cell filled

[Undo]

Hey

I have table, contains entry text cells and formula cells
I want if user write in any entry cells, then highlight the other empty entre cells in same row to remind him to fill it
without highlight the formula cells
using conditional formatting
Thanks

[AliGW]

Formula CF rule for the ranges required:

=$B2<>""

[Undo]

Not only based on B2, based in all entre cells in same row
if any is filled, then highlight all empty entry cells in same row (without mention cells - black )

[popipipo]

Please Login or Register  to view this content.

maybe this formula will work