psionic
10-18-2007, 10:21 PM
Hello again. :hi:
Found a new problem.:help Is there is a solution for this one.
Is there a way to filter using the AutoFilter based on background colour not text colour. :think:
It gets VERY hard to read if black colour is changed to something else. :doh:
The reason is this, I already have a dynamic list that grows unpredictable from a database and selected the autofilter in order to select "(Blanks)" so I can know what records are missing fields.
During the course of day, I have been using the background colour to change the entire row when done checking in database.
This is handy as I always get interrupted by phones or other company so when i come back I know where I am at by looking at the colours not done. :yes
Any ideas. This is similar to Conditional Autoformatting I think....
Thanks and warm regards,
Psionic
Found a new problem.:help Is there is a solution for this one.
Is there a way to filter using the AutoFilter based on background colour not text colour. :think:
It gets VERY hard to read if black colour is changed to something else. :doh:
The reason is this, I already have a dynamic list that grows unpredictable from a database and selected the autofilter in order to select "(Blanks)" so I can know what records are missing fields.
During the course of day, I have been using the background colour to change the entire row when done checking in database.
This is handy as I always get interrupted by phones or other company so when i come back I know where I am at by looking at the colours not done. :yes
Any ideas. This is similar to Conditional Autoformatting I think....
Thanks and warm regards,
Psionic