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
|