View Single Post
  #2   Report Post  
Patti
 
Posts: n/a
Default

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.



"colettey29" wrote:

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