| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an If Formula with Conditional Formatting
Using Excel 2000; Hi everyone, Help please
1?: Red. If the value that is caluculated in cell B41 is =to or less then the value in Cell B42 by 1% turn Red. Actual value in cell B41 and B42 are whole numbers. B42 is a sum of several cells above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. 2?: Light Green. If the value that is caluculated in cell B41 is = to or greater then by .2999 then the value in Cell B42 turn light green. Actual value in cell B41 and B42 are whole numbers. B42 is a sum of several cells above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. 3?: Dark Green. If the value that is caluculated in cell B41 is = to or greater then by 30% then the value in Cell B42 turn dark green. Actual value in cell B41 and B42 are whole numbers. B42 is a sum of several cells above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an If Formula with Conditional Formatting
See the reply to your message in another group. Please don't multipost.
-- David Biddulph "Cali" wrote in message ... Using Excel 2000; Hi everyone, Help please 1?: Red. If the value that is caluculated in cell B41 is =to or less then the value in Cell B42 by 1% turn Red. Actual value in cell B41 and B42 are whole numbers. B42 is a sum of several cells above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. 2?: Light Green. If the value that is caluculated in cell B41 is = to or greater then by .2999 then the value in Cell B42 turn light green. Actual value in cell B41 and B42 are whole numbers. B42 is a sum of several cells above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. 3?: Dark Green. If the value that is caluculated in cell B41 is = to or greater then by 30% then the value in Cell B42 turn dark green. Actual value in cell B41 and B42 are whole numbers. B42 is a sum of several cells above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting in a formula | Excel Discussion (Misc queries) | |||
| Conditional Formatting Formula | Excel Worksheet Functions | |||
| what formula do I use for conditional formatting? | Excel Worksheet Functions | |||
| Conditional formatting and formula | Excel Worksheet Functions | |||
| conditional formatting or formula | Excel Worksheet Functions | |||
Linear Mode
