How to populate a cell based on font color/threshold
I'm totally in the dark on this so any help would be greatly appreciated! I
have a spreadsheet that lists my call center staff in one column and their associated pause and login state times in other columns within the same row. I have conditional formatting set on the pause state and login state cell data to turn the font color to red when tresholds are met. I need a way to automatically compile on a second worksheet only those staff names where their respective pause time cell data meets or exceeds a specified threshold limit or/and font color is red. I also need the actual pause, login data meeting the tresholdlevl to populate in the second worksheet. I am using Excel 2007 Thank you, Anthony |
How to populate a cell based on font color/threshold
Though you could filter a list by font color using VBA, this approach is
not possible with font colors produced by conditional formatting. What you need is an additional helper column with a formula that checks for the condition (which would probably the same as you are already using for your conditional formatting) and inserts a marker, e.g. =IF(<condition, "X","") .. You could then use Excel's standard filter techniques to full out all rows containing the marker. Joerg "ascottbag-hcm" wrote in message ... I'm totally in the dark on this so any help would be greatly appreciated! I have a spreadsheet that lists my call center staff in one column and their associated pause and login state times in other columns within the same row. I have conditional formatting set on the pause state and login state cell data to turn the font color to red when tresholds are met. I need a way to automatically compile on a second worksheet only those staff names where their respective pause time cell data meets or exceeds a specified threshold limit or/and font color is red. I also need the actual pause, login data meeting the tresholdlevl to populate in the second worksheet. I am using Excel 2007 Thank you, Anthony |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com