Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font color dipicts which formula to use
Is there a way in Excel to have two different formulas and if the number in
the cell color in black it uses one formula and if the color of the number in the cell is red it uses a different formula? Example: 40 hours of payroll multiplies the hourly wage by the 40 hours if 43 hours in red color font the formula would say if 40 then multiply the 40 hours by the regular hourly wage and the 3 by a differently wage, but if the font color was still black it would multiply all 43 hours by the regular wage? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font color dipicts which formula to use
If you are using 2007, when on the "Home" ribbon, go down to "Styles" from
there, go into "Conditional Formatting" Go down all the way to the bottom and create the new rule. Of course, you first want to select all the Rows/Columns that you are wanting to apply the rule to. Hope this has been of assistance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font color dipicts which formula to use
Hi,
If you are not using xl2007, it's a bit more complex. You can't change the formula according to font colour without using a macro. But you can use one of the criteria that you used to colour the cells in the first place, and put it into an IF formula. eg: IF(criteria_Black,Formula1,Formula2) This says that if the text is black, use formula1, otherwise use Formula2. If you need help with the syntax of the IF formula, supply details of the colour criteria and the formulas you want to use. Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change font/cell color by Formula | Excel Worksheet Functions | |||
font color for formula answer | Excel Discussion (Misc queries) | |||
I need to use a formula to pick up a value by the font color? | Excel Discussion (Misc queries) | |||
Formula results in font color change | Excel Worksheet Functions | |||
Can Formula Change the Font Color? | Excel Worksheet Functions |