Formatting an entire row based on one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If the value in Column 6 of a specific row is equal to 1, I would like to
highlight that entire row... I'm having trouble with the "row" function of
the formula.
Any ideas?
-c
 
Will this work:

Highlight the applicable columns, choose Conditional Formatting, select
'Formula Is' and enter

=countif($F1,1)=1

and choose a color. This should highlight the applicable row if the cell in
column F has 1 in it.
 
Perhaps this would also work as well ..

Press CTRL+A to select the entire sheet
(the initial selection step is important in CF)

Click Fornat > Conditional Formatting

Under Condition1

Formula Is | =$F1=1
(note the "$" sign above)

Click Format > Patterns tab > Gray? > OK

Click OK at the main dialog

Now test it out by inputting 1's within any/several cells in col F,
and the entire row(s) will be filled gray ..
 
You must log in or register to reply here.

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 format a column based on value in a different column 3
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
Excel VBA 1
Conditional formatting for rows 7
Highlighting the entire row with conditional formatting 10
[XL07] Conditionally format fill color for entire row 10
Highlighting Entire Row using CF 3
Excel Help to copy information from one row at a time to another sheet 1

Back
Top