Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering an If formula using conditional formatting
Hi everyone: I need your help for I need to know how to do this for work. I
have three condiontions Red, Light green, and Dark green. 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 cell 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 cell 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 cell above and changes every day. However, the whole number entered into cell B42 only changes 1 time a month. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting and Entering Dates with out dashes | Excel Discussion (Misc queries) | |||
conditional formatting when entering a date | Excel Worksheet Functions | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) |