| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statement and cell formatting
Hi everyone
Here is what I'm trying to do, I have that spreadsheet and I need to make a if statement for a cell that will compare 2 other cell and change the background color to yellow whenever cell1 0.8*cell2. thx for your help malpropio. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if statement and cell formatting
You'll have to use conditional formatting. Assuming that cell 1 is A1,
Cell 2 is A2, and the cell with the formatting is A3. Select cell A3 and then go to Format-Conditional Formatting and pick 'Formula Is" and type the formula: =A10.8*A2 The click the Format button, got to patterns and pick the color you want the cell to be. On Mar 13, 1:17 pm, "malpropio" wrote: Hi everyone Here is what I'm trying to do, I have that spreadsheet and I need to make a if statement for a cell that will compare 2 other cell and change the background color to yellow whenever cell1 0.8*cell2. thx for your help malpropio. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Formatting of a Conditional Statement | Excel Worksheet Functions | |||
| Cell formatting and if statement | Excel Discussion (Misc queries) | |||
| IF statement and color formatting for cell B1 for condition in A1 | Excel Worksheet Functions | |||
| formatting a cell with a function (IF statement) | Excel Worksheet Functions | |||
| Formatting a cell with a function (IF statement) | Excel Worksheet Functions | |||
Linear Mode
