how to highlight a row using conditional formatting ?

[ziva770]

Guys,
I need a simple formula for the following task -

I have a sheet with 3 columns
i want excel to highlight THE ENTIRE ROW if ALL cells are blank

something like ...if (a1)AND(b1)AND(c1)=blank THAN row=red

How can I write it as an Excel formula?

Many Thanks!

[sweep]

Hi,

Highlight column D from the first cell that requires conditional formatting down.

Presuming that's D1, use

=A1&B1&C1=""

as your formula

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[ziva770]

Sweep,
I would like to highligh the ENTIRE row if A1 AND A2 AND A3 are blank
How can I do that? Thanks

[Cutter]

With the entire rows selected as far down as you need to go use this as the formula in your CF:

Please Login or Register  to view this content.

(assuming you want to start with row 1)

[ziva770]

Cutter thank you very much it works like charm!