| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Useing IF statements to change a cell color
I know this has been beat to death but I just cant seem to figure it out.
This is what I want to do =IF(94<D8<97,[change cell color to red],[do nothing]) I have tried the conditional formatting but the value in D8 is referenced from another page in the same worksheet. How can I get this to work? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Useing IF statements to change a cell color
It will be a conditional format. A cf wants either a true or false answer. So
for your example this formula should do =and(D894, D8<97) which will colour the cell based on your formatting choice when D8 is between 94 and 97... -- HTH... Jim Thomlinson "edward/" wrote: I know this has been beat to death but I just cant seem to figure it out. This is what I want to do =IF(94<D8<97,[change cell color to red],[do nothing]) I have tried the conditional formatting but the value in D8 is referenced from another page in the same worksheet. How can I get this to work? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color of a box with using if statements | Excel Worksheet Functions | |||
| Change cell color for more than 3 conditional statements | Excel Worksheet Functions | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| can i setup if, then statements to change the color of a row | New Users to Excel | |||
| Useing a Logrithmic y=intercept in a cell | Excel Worksheet Functions | |||
Linear Mode
