I have a spreadsheet that I want to use a formula to conditionally format the
spreadsheet but there are too many ANDs and IFs and I'm getting confused and
I need some help, please.
It's set up like this:

A B C D E
Name Lodging Mileage Other Invoice#

1 Joe Smith 45.00 100.00 9.00 1990
2 Ann Jones 44.00 4444
3 Jesse Smith 43.00 99.00 7777
4 Alfred Jones 77.00 1234

I need a formula that will highlight the row (or even just highlight the
cell containing the name) a certain color when lodging, mileage AND other are
not blank cells, another color when just lodging is not blank cell, another
color when lodging and mileage are not blank cells and another color when
just mileage is not a blank cell.
Can this be done?

Thank you,
Studebaker