Conditional Filter

C

carl

is it possible to have a row highlighted if a value in a cell is greater than
25 ?

eg.

cx v 24
dx v 50

row 2 would be highlighted.
 
D

Domenic

Assuming that Columns A, B, and C contain your data...

1) Select your data

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:
=$C1>25

4) Choose your formatting

5) Click Ok

Hope this helps!
 
A

Alan

Yes,
Select A2
Use Format > Conditional Formatting
Select 'Formula Is' and enter this formula
=COUNTIF(2:2,">"&25)
Select A2:IV2 > Format > Conditional Formatting
OK
Regards,
 
Top