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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indenting every other paragraph in Word at the same time? 0
Need Help with a VBA subroutine 0
Conditional Formatting question.... 1
VLOOKUP plus IF 1
Conditional Formatting to Another Cell 0
How to use the Stop If True Condition for highlight cells 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Conditional formatting based on character count 1

Top