How do I format a row depending on the value of a cell in the row

G

Guest

I have a table set up and would like any row of the table where a particular
cell in the same row is blank to be highlighted. In other words, for any cell
in column J that is blank, I want the corresponding row to be highlighted.

I'm trying the conditional formating 'Formula Is' but so far it's not
working for me. Any ideas?
 
G

Guest

Select the whole table, assume the table is A1:D10, so formula is should be

=COUNTBLANK($A1:$D1)>0


replace A1 with the left uppermost cell in your table that you want to test
for and D1 with the right uppermost cell, notice the mixed relative absolute
references (dollar signs)


regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting Entire Row Based on single Cell Value 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
colour of a row depending on cell value 6
Excel VBA 1
Auto insert a blank row above the current row based on a cell val. 2
Conditional formattion for whole row based on one cell value 3
Highlighting row of active cell question 4
Conditional format lowest value greater than zero and copy formula 2

Top