Conditional Formatting for entire row

[lhk201]

I have using conditional formatting over a range of cells using the following formula to turn the cell red:

=IF($CA$5=R$1,ISBLANK(R11))

However this just makes each relevant cell red whereas I woud like to turn that entire row red.

Does anyone have any ideas on how to solve this?

Thanks for your time!

 

[Xenoun]

Highlight the entire row and then use excel's built-in conditional formatting, its fairly straight forward

 

[lhk201]

I have tried that many times! Unfortunately with this type of formula it doesn't work :s

 

[lhk201]

This is currently the conditional formula for the entire range of cells but it only highlights the blank cell...

 

[baodinh]

Add a first condition for all cells in column R that if S1 = 1, turn the cell red. There could be a second condition to turn the cell red if the cell is blank. Then you'd write a formula in cell S1 to decide what condition should the value be 1 to turn the entire column R red.

 

[Ganjin]

I have using conditional formatting over a range of cells using the following formula to turn the cell red:

=IF($CA$5=R$1,ISBLANK(R11))

However this just makes each relevant cell red whereas I woud like to turn that entire row red.

Does anyone have any ideas on how to solve this?

Thanks for your time!

So you want to highlight a row, if the value in Column R matches the value in CA5 and only if R11 is blank, correct?

In that case, this should achieve the desired result:
=IF($R1=$CA$5,ISBLANK($R$11))