CODEWITHSUNDEEP
excel
A Hughes
A Hughes

Reputation: 265

How to Conditional Format Full Rows

Is there a away to format rows of cells, so when data is entered in A1, the rest of row A turns red? The reds will disappear as each row cell is updated? Something like this works =IF(A2="","",B2=""), but it only flags reds as you type

Upvotes: 0

Views: 70

Answers (2)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60174

"A" is not a row. It is a column.

Edit Perhaps this -- it took me a while to understand what you wrote, even though, in retrospect, it was pretty clear.

An entry in column A highlights the rest of the row (up to column V) An entry in any other cell removes the highlight from that single cell:

Formula:

=AND($A1<>"",A1="")

enter image description here

enter image description here

Upvotes: 1

teylyn
teylyn

Reputation: 35900

As I understand you want to highlight the whole row if only column A contains a value. If any other cell contains a value, the highlight shall disappear.

Select the desired rows and create a conditional format with this formula:

=AND(LEN($A1)>0,COUNTA(1:1)=1)

enter image description here

Upvotes: 1

Related Questions