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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 09:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com