Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell turn red if value is less than 0?
i have a list of numbers on my worksheets, inclusing some zeros. i would a
formula that means whenenver a cell just has 0 in it it will show as red. Is this possible? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell turn red if value is less than 0?
Use conditional format ,,,, where cell value equals "0" ,,, format to RED
"Megglesface" wrote: i have a list of numbers on my worksheets, inclusing some zeros. i would a formula that means whenenver a cell just has 0 in it it will show as red. Is this possible? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell turn red if value is less than 0?
1) Select all the cells that have numbers.
2) Format-ConditionalFormatting 3) Under Condition1 Cell Value is ... Equal To ... 0 Click the format button & give any format that you want. This will change all 0's to that color/format. HTH, -- Tausif Mohammed "Megglesface" wrote: i have a list of numbers on my worksheets, inclusing some zeros. i would a formula that means whenenver a cell just has 0 in it it will show as red. Is this possible? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell turn red if value is less than 0?
thats great, thanks
"John Moore" wrote: Use conditional format ,,,, where cell value equals "0" ,,, format to RED "Megglesface" wrote: i have a list of numbers on my worksheets, inclusing some zeros. i would a formula that means whenenver a cell just has 0 in it it will show as red. Is this possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make cell turn red or green? Please help... | Excel Discussion (Misc queries) | |||
how to make cell turn red or green? Please help... | Charts and Charting in Excel | |||
Make cell turn different colour | Excel Worksheet Functions | |||
make it easy to turn off the little paste option graphics | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |