Conditional formatting - turn blank cell yellow and when text entered blank on

Test this out.

I think 1 and 2 work fine, but I'm struggling to understand your requirement for rule 3?

CONDITIONAL FORMATTING - CELLS TURN BLANK WHEN TEXT ENTERED updated.xlsx

Cheers
Nico

First of all, remove the manual colour that you have set in your sample file, then select the range of cells B2:E10 and click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box which pops up:

=AND($A2<>"",B2="")

Click on the Format button | Fill tab and click on Yellow, then OK your way out.

Hope this helps.

Pete

Whoops! Small tweak. I only read your instructions in the file. I had another look a the rules here in the thread and it now makes more sense.

You want to apply colours for empty cells. But ONLY if there is a value in col A. If there is no value in col A then there is no formatting in that row, regardless of whether a cell is blank or not.

Check out rows 12-14.

I created this rule for the range $B$12:$E$14
=AND(NOT(ISBLANK($A12)),ISBLANK(B12))

CONDITIONAL FORMATTING - CELLS TURN BLANK WHEN TEXT ENTERED updated2.xlsx

Ignore the previous post.

Ok, third time lucky...

I see you had a rule in the workbook that was not stated on the thread:

"Once text is entered in column A then all cells get a border".

Please refer attached, it should be fine now.

I added a second rule, as follows:
=NOT(ISBLANK($A12))

And when this rule is true, the entire row get borders, from col A to col E.

CONDITIONAL FORMATTING - CELLS TURN BLANK WHEN TEXT ENTERED updated3.xlsx

Thank you very much.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete