Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet that shows employee names/positions in column A, followed
by monthly salary in columns B through M. Some rows will have blank values for several months depending on whether a particular person/position is going to be hired/fired/etc. I need to create a duplicate worksheet that will show the same names/positions, but doesn't show the $ amounts. For example, if a certain position was empty until March, I would want the Jan & Feb cell to remain blank and the March-Dec cell to contain an indicator of the presence of a value, this could be just an "x" to indicate that in the original worksheet the cell was populated with a salary. the purpose is so that I have a separate worksheet to distribute to managers to plan their headcount month-by-month without disclosing confidential salary information. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Conditional formatiing based on another cell | Excel Discussion (Misc queries) | |||
Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
Conditional formatting a full row triggered by a single cell | Excel Worksheet Functions | |||
Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions |