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" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
>
>
> --
> hmmm
> ------------------------------------------------------------------------
> hmmm's Profile:
http://www.excelforum.com/member.php...o&userid=25836
> View this thread: http://www.excelforum.com/showthread...hreadid=481784
>

[hmmm]

thanks!

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