hi hope theres a way to do this.
i have a spreadsheet which is used to keep the training records for the company
it counts no of staff and their skill levels for different parts of the job, when a person moves to a different branch the
skill required changes and they have a set period of time to aquire the new skill.
when the time is up the colour
of the old skill is changed to a red font by a conditional format based on the date.this is then counted by a calculation so
the team know how many people are to be targeted for extra training.
the problem i have is the calculation will
not count conditionally formated cells, so whenever i update the sheet i have to go to each cell with red text and change the
font colour manually to red, this sounds really silly and is impossible to explain to anyone who does not understand
conditional formatting. i e the people who will end up using the database
what im looking for is a way to count
conditionally formatted cells based on the condition being met i.e. they are showing as red font.
can it be done
or am i wasting my time looking for an answer to something excel wont do ?