Can I change font/color if value is less than another value?

J

jmay35

I have one cell picking up and adding together data from several diferent
cells. Can I formulate the cell to change font or color if the data faals
below a minimum level?
 
M

Marcelo

hi,

format | conditional format
set your condition <x and format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"jmay35" escreveu:
 
K

Kevin B

Select the cell that you want to format and click FORMAT in the menu and
select CONDITIONAL FORMATTING. State the criteria and the format to apply.
Fonts, borders and patterns can be assigned using this method.
 
Top