| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Formula to fill cell using %
Using Excel 2007, I have dollar values in columns A, B and C. C=B-A. I
would like to highlight the cells in column C red if the cell value is greater than 5% of the value in column A. Here is my formula, can someone please tell me what I'm doing wrong? The formatting highlights every cell, regardless of it's value. =$C$2($A$2*0.05) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting - Formula to fill cell using %
Get rid of your absolute references (the $'s). Then try it again. HTH. "sbres" wrote: Using Excel 2007, I have dollar values in columns A, B and C. C=B-A. I would like to highlight the cells in column C red if the cell value is greater than 5% of the value in column A. Here is my formula, can someone please tell me what I'm doing wrong? The formatting highlights every cell, regardless of it's value. =$C$2($A$2*0.05) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting - Formula to fill cell using %
Hi,
Try this =$C2($A2*0.05) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "sbres" wrote in message ... Using Excel 2007, I have dollar values in columns A, B and C. C=B-A. I would like to highlight the cells in column C red if the cell value is greater than 5% of the value in column A. Here is my formula, can someone please tell me what I'm doing wrong? The formatting highlights every cell, regardless of it's value. =$C$2($A$2*0.05) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting / Cell Fill Colours | New Users to Excel | |||
| Conditional formatting to a different cell and it contains a formula | Excel Worksheet Functions | |||
| fill autoshape color with ref cell conditional formatting | Excel Worksheet Functions | |||
| Conditional Formatting on cell with a formula | Excel Worksheet Functions | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Hybrid Mode
