Formulas to highlight cell if condition is met
 

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

Formulas to highlight cell if condition is met
 

No you can use conditional formatting

Select the cell
Menu FormatConditional 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 DataValidation
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" wrote in message
...

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

Formulas to highlight cell if condition is met
 

thanks!

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


--
hmmm
------------------------------------------------------------------------
hmmm's Profile: http://www.excelforum.com/member.php...o&userid=25836
View this thread: http://www.excelforum.com/showthread...hreadid=481784