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 |