Conditional format for 2 conditions

[dtrevor]

Hi

Is it possible to automatically highlight all blank cells a row only if the first cell in that row is not blank?
I want to do this for the whole table

Thanks in advance

Trevor

[TMS]

Yes.

Select all the cells from A1 to the bottom of the table.

Please Login or Register  to view this content.

Regards, TMS

[dtrevor]

Thanks Trevor,

Works 100% ,
I did have a little bit of trouble with it though.
I had to select all the cell in the table except for column 1 and then type in the rule and click apply and then the values of the rule would be change to the end values of the table, then I had to edit the rule back to the formula you gave and then it worked.
Thanks again,

Trevor

[dtrevor]

P.s. I didn't find anywhere on the forum page to mark the post as solved otherwise I would have!

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[dtrevor]

I did it now, it certainly could be made a bit more obviously!
Like adding an option Mark as correct next to the reply option.