Formulas to highlight cell if condition is met

[hmmm]

i wonder if there is any way i can highlight a cell if a condition is
met?

eg i want to highlight the cell if the num in the cell is greater than
1. do i hv tio use macros?

 

[Bob Phillips]

No you can use conditional formatting

Select the cell
Menu Format>Conditional Formatting
Set to greater than
Set value to 1
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK


You could even use Data validation to not allow entry of greater than 1

Select the cell
Menu Data>Validation
Change ALlow to Decimal
Change the operator to Less than or equal to
Set a value of 1
OK

With DV, you can even set your own error message.


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[hmmm]

thanks!

i've tried and it's really useful =)