Conditional Format - Highlight only blank cells in row if empty (Not entire row)

[surkdidat]

In conditional format, if I want to highlight any cell in a row that is blank , IF Column A states "Rejected" (Cells go from A: BG ) how do i do this please?

 

[Joe4]

For row 1, the formula would look like:

=AND($A1="Rejected",A1="")

and choose your highlighting color.

To apply this to a whole large range, select all the cells that you want to apply it to, and then write the formula as it applies to the VERY first cell in your range.
If you use the Absolute/Relative range references correctly (like I did above), it will automatically adjust for all other cells.

 

[Twollaston]

In conditional format, if I want to highlight any cell in a row that is blank , IF Column A states "Rejected" (Cells go from A: BG ) how do i do this please?

if the blank is a result of a formula then
=AND(B1="",$A1="Rejected")

If the cell is just empty
=AND(ISBLANK(B1),$A1="Rejected")

either or
=OR(AND(ISBLANK(B1),$A1="Rejected"),AND(B1="",$A1="Rejected"))


highlight the cells starting with B1 and apply the formula that is relevant to you as a conditional formatting formula

 

[Joe4]

I should have clarified, that my solution assumes that you are including column A in your range selection (kind of "assumed" when I said row 1, but may not be 100% clear).
Obviously, column A will never be highlighted, as it is impossible for both conditions to be true for any value in column A.
So you could, alternatively, start your range selection in range B, like Twollaston did.

They should both work just fine, though looking back on it, applying it to one less column is probably a little more efficient.

 

[surkdidat]

thank you - works perfectly

For row 1, the formula would look like:

=AND($A1="Rejected",A1="")

and choose your highlighting color.

To apply this to a whole large range, select all the cells that you want to apply it to, and then write the formula as it applies to the VERY first cell in your range.
If you use the Absolute/Relative range references correctly (like I did above), it will automatically adjust for all other cells.