Conditional Formating a Row

  • Thread starter Thread starter Calman
  • Start date Start date
C

Calman

Is it possible to have an entire row highlighted if a
specific condition exists in the first column of the row ?

Regards and thanks in advance.
 
Hi

Select the row. Format / Conditional Formatting. Set the option to Formula
is: and have
=$A$1=25
for example

Andy.
 
Hi
try the following example (check if a1 is greate than 1):
- highlight row 1
- goto 'format - Conditional format'
- enter the following formula
=$A1>1
- choose your format
 
Back
Top