Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing Formula For conditional Formatting Using Excel 2000
Hi Everyone: Does anyone know how to write three seperate formulas for these
questions in the conditional formatting box Using Excel 2000? 1?: Red. If the value that is calculated in cell B42 is = to or less then the value in Cell B43 turn Cell B42 Red. Actual value in cell B42 and B43 are whole numbers 2?: Light Green. If the value that is calculated in cell B42 is between 1% and 29.99% greater than the value in Cell B43 turn Cell B42 light green. 3?: Dark Green. If the value that is calculated in cell B42 is greater by 30% or more then the then the value in Cell B43 turn Cell B42 dark green. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing Formula For conditional Formatting Using Excel 2000
condition 1 cell value is, less than or equal to, =$B$43 condition 2 cell value is, between =$B$43+(0.01*$B$43), =$B$43+(0.2999*$B$43) condition 3 cell value is, greater than or equal to, =$B$43+(0.3*$B$43) "Cali" wrote: Hi Everyone: Does anyone know how to write three seperate formulas for these questions in the conditional formatting box Using Excel 2000? 1?: Red. If the value that is calculated in cell B42 is = to or less then the value in Cell B43 turn Cell B42 Red. Actual value in cell B42 and B43 are whole numbers 2?: Light Green. If the value that is calculated in cell B42 is between 1% and 29.99% greater than the value in Cell B43 turn Cell B42 light green. 3?: Dark Green. If the value that is calculated in cell B42 is greater by 30% or more then the then the value in Cell B43 turn Cell B42 dark green. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing Formula For conditional Formatting Using Excel 2000
Hi Joe: I can't get number 2 and three to work. I went to the section Cell
value is and not the section where you type in the Formula is. Do you have any other suggestions. "joemeshuggah" wrote: condition 1 cell value is, less than or equal to, =$B$43 condition 2 cell value is, between =$B$43+(0.01*$B$43), =$B$43+(0.2999*$B$43) condition 3 cell value is, greater than or equal to, =$B$43+(0.3*$B$43) "Cali" wrote: Hi Everyone: Does anyone know how to write three seperate formulas for these questions in the conditional formatting box Using Excel 2000? 1?: Red. If the value that is calculated in cell B42 is = to or less then the value in Cell B43 turn Cell B42 Red. Actual value in cell B42 and B43 are whole numbers 2?: Light Green. If the value that is calculated in cell B42 is between 1% and 29.99% greater than the value in Cell B43 turn Cell B42 light green. 3?: Dark Green. If the value that is calculated in cell B42 is greater by 30% or more then the then the value in Cell B43 turn Cell B42 dark green. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing Formula For conditional Formatting Using Excel 2000
do you have less than or equal to for the first condition? if you accidently
chose greater than or equal to, it will cause the other conditions to fail "Cali" wrote: Hi Joe: I can't get number 2 and three to work. I went to the section Cell value is and not the section where you type in the Formula is. Do you have any other suggestions. "joemeshuggah" wrote: condition 1 cell value is, less than or equal to, =$B$43 condition 2 cell value is, between =$B$43+(0.01*$B$43), =$B$43+(0.2999*$B$43) condition 3 cell value is, greater than or equal to, =$B$43+(0.3*$B$43) "Cali" wrote: Hi Everyone: Does anyone know how to write three seperate formulas for these questions in the conditional formatting box Using Excel 2000? 1?: Red. If the value that is calculated in cell B42 is = to or less then the value in Cell B43 turn Cell B42 Red. Actual value in cell B42 and B43 are whole numbers 2?: Light Green. If the value that is calculated in cell B42 is between 1% and 29.99% greater than the value in Cell B43 turn Cell B42 light green. 3?: Dark Green. If the value that is calculated in cell B42 is greater by 30% or more then the then the value in Cell B43 turn Cell B42 dark green. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003 | Excel Worksheet Functions | |||
Conditional Formatting - 3 Rules - Excel 2000 | Excel Worksheet Functions | |||
Excel 2000 - Conditional Formatting | Excel Discussion (Misc queries) | |||
Excel 2000 - Conditional Formatting | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) |