| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change font/color if value is less than another value?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change font/color if value is less than another value?
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: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change font/color if value is less than another value?
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. -- Kevin Backmann "jmay35" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Find function | Excel Worksheet Functions | |||
| Find function | Excel Worksheet Functions | |||
| Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Linear Mode
