If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If formulations
Seems like this should be simple but not for me I guess. I have projected
dept hours/dollar amount vs. actual costs in 4 columns with sum total at the bottom, B3:B16, C3:C16, ect. I need column D17/E17 to be highlighted in red if larger than A7/B17, but black if less than or equal to. In addition, I need the numbers in D/E 3-16 to be in red if greater than A/B 3-16. Trying to get it to highlight depertments overages on hours and actual dollars. Thanks in advance for any advice someone provide. Matt David |
#2
|
|||
|
|||
If formulations
Lets start with cells D316. Select them all and then choose
Format -- Conditional Formatting In the dialog choose the "cell value is" and "greater than" and type in =A3 into the remaining area. Then click the [Format] button and set up the format you want. Excel will take care of changing A3 to A4, A5...A16 for you. Select E3:E16 and repeat except type in =B3 in that last section for defining the format condition. D17 and E17 are more straight-forward since you only compare to one cell, either A17 or B17. Set them up exactly the same way, just choosing the single cell, D17 and E17 for each. I hope this helps you get you going on this. "MDD" wrote: Seems like this should be simple but not for me I guess. I have projected dept hours/dollar amount vs. actual costs in 4 columns with sum total at the bottom, B3:B16, C3:C16, ect. I need column D17/E17 to be highlighted in red if larger than A7/B17, but black if less than or equal to. In addition, I need the numbers in D/E 3-16 to be in red if greater than A/B 3-16. Trying to get it to highlight depertments overages on hours and actual dollars. Thanks in advance for any advice someone provide. Matt David |
#3
|
|||
|
|||
If formulations
Worked like a charm, thanks very much for your help.
"JLatham" wrote: Lets start with cells D316. Select them all and then choose Format -- Conditional Formatting In the dialog choose the "cell value is" and "greater than" and type in =A3 into the remaining area. Then click the [Format] button and set up the format you want. Excel will take care of changing A3 to A4, A5...A16 for you. Select E3:E16 and repeat except type in =B3 in that last section for defining the format condition. D17 and E17 are more straight-forward since you only compare to one cell, either A17 or B17. Set them up exactly the same way, just choosing the single cell, D17 and E17 for each. I hope this helps you get you going on this. "MDD" wrote: Seems like this should be simple but not for me I guess. I have projected dept hours/dollar amount vs. actual costs in 4 columns with sum total at the bottom, B3:B16, C3:C16, ect. I need column D17/E17 to be highlighted in red if larger than A7/B17, but black if less than or equal to. In addition, I need the numbers in D/E 3-16 to be in red if greater than A/B 3-16. Trying to get it to highlight depertments overages on hours and actual dollars. Thanks in advance for any advice someone provide. Matt David |
Thread Tools | |
Display Modes | |
|
|