Conditional Formatting per specific requirement

[ME_Cruz81]

Hello everyone,

I think I am over thinking this and missing it altogether.

I am trying to get the table to only highlight the blank cells to the right when there is text in column "F" for the remaining cells in the row, if there is no text in "F" than no highlighting of the row. at all.

Basically showing if you start entering information you have to complete the entry.

Thanks in advance for any assistance. ;)

[#2]

@ME_Cruz81 

You need to do this:

• Formula used:

=AND(NOT(ISBLANK($C191)),ISBLANK($D191))

• Adjust cell references in the formula as needed.

[#3]

@Rajesh_Sinha 

Thank you so much! That did the job perfectly!!!

I really appreciate your assistance with this issue.

[#4]

Glad to help you, since my suggestion works for you then you may mark it as Best Answer as well Like,, and keep asking ☺