Fill blank cells with color in Excel

[BMD4]

Hello,

I have a requirement where if CoCode (Col J) is not blank and any other cells are blank.the blank cells are filled in red color.

I have written the code to fill the cells, but it give 400 error. Attached the file. Please advice what is missing in the code.

Thanks in advance

[chronjy]

Please Login or Register  to view this content.

[BMD4]

Thanks Chronjy.

This works, but my requirement is to have this enabled only if col J is not blank. I see this works for all the rows with in the range where we do not have any data submitted.

[jindon]

I have a requirement where if CoCode (Col J) is not blank and any other cells are blank.the blank cells are filled in red color.

Please Login or Register  to view this content.

[BMD4]

Thanks Jindon.

Can you please let me know how can we limit the number of columns to which the logic is applied. Eg: non sequential columns. Col 5 and 7

[jindon]

Eg: non sequential columns. Col 5 and 7

Please Login or Register  to view this content.

[BMD4]

can you please help me understand what is RC10 and RC in the logic

[jindon]

That's R1C1 notation for cell address reference.
r = same row, c10 means col.10 = "J"
rc = cell that the conditional formatting will be applied to.

so that you can change base column "E"

Please Login or Register  to view this content.

to any other column, if needed.

[BMD4]

Hi Jindon,

I see the logic is applied to all the columns. Attached the file. Can you pelase advise.

[jindon]

If so, you didn't delete the remaining conditional format.

Please Login or Register  to view this content.