formating formula question

  • Thread starter Thread starter ram1000
  • Start date Start date
R

ram1000

I want to format a non-specific row if a condition is true. If the wor
"final" is placed in a non-specific cell I want the entire row to b
formated with a light green background and black alpha-numeric digits.

Thank yo
 
Suppose you're evaluating rows 1-100 and "non-specific
cell" means any cell in the row:

1. Select rows 1-100.
2. Go to Format > Conditional Formatting
3. Select "Formula Is" and insert:
=OR(1:1="final")
4. Press the "Format" radio button and format as desired.

HTH
Jason
Atlanta, GA
 
I followed the directions but it says there is a formula error.

This is what I put in:

=OR (1:1="final"
 
Hi
just remove the SPACE after the function name. that is change
=OR (1:1="final")
to
=OR(1:1="final")

HTH
Frank
 
Works for me. The extra space may be causing an issue.
I'm using WinXP/XL2002 but that shouldn't be an issue.

HTH
Jason
Atlanta, GA
 
Back
Top