Whyte_Rhyno
New Member
- Joined
- Mar 30, 2011
- Messages
- 2
Hello all,
Been lurking here for a few weeks now picking up new techniques, I want to thank you all for the great tutorials and knowledge you guys have shared.
I'm in the midst of a couple of book tutorials but have become stuck while trying to improve on a particular exercise.
I have 4 departments with a 2 tier staffing level and allocation of funds (a formula) is based upon the number of staff in each, as well as the number of tier 1 staff.
Problem:
Basically, I'm looking for a way that allows for a condition that if the "Directors" department has less than, say, £32,000, there's a pop-up that informs the user that the Directors do not have enough funds.
This is obviously quite easy with a conditional format, however, data can be sorted numerically and alphabetically and when it's done so, the other departments within the cell get the conditional format. I want just the directors to be conditionally formatted.
I am a newbie to Excel, so I'm no doubt missing the obvious.
I appreciate you time. Attached is a jpg of my basic spreadsheet.
Been lurking here for a few weeks now picking up new techniques, I want to thank you all for the great tutorials and knowledge you guys have shared.
I'm in the midst of a couple of book tutorials but have become stuck while trying to improve on a particular exercise.
I have 4 departments with a 2 tier staffing level and allocation of funds (a formula) is based upon the number of staff in each, as well as the number of tier 1 staff.
Problem:
Basically, I'm looking for a way that allows for a condition that if the "Directors" department has less than, say, £32,000, there's a pop-up that informs the user that the Directors do not have enough funds.
This is obviously quite easy with a conditional format, however, data can be sorted numerically and alphabetically and when it's done so, the other departments within the cell get the conditional format. I want just the directors to be conditionally formatted.
I am a newbie to Excel, so I'm no doubt missing the obvious.
I appreciate you time. Attached is a jpg of my basic spreadsheet.