I know that conditional formatting can be a problem. But, can you minimize it?
Example: I currently highlight the entire row of data (85 columns) when the persons status changes to TERMINATED or OUT TILL FURTHER NOTICE or LEAVE OF ABSENSE or TEMP WORKING OUT OF AREA etc.
In the past I think I had some workbook issues due to that. If I reduce the application so that the rule is applied only to a cell vice the row would that help do you think? Or instead of coloring the entire row maybe just coloring the font in that row?
There's a lot of people to track and CF makes it easy at a glance. But if I can use it with less risk of errors or issues I'd love to.
What do y'all think? And, as always I am extremely grateful for the time everyone takes to read and reply. Thank you.
Example: I currently highlight the entire row of data (85 columns) when the persons status changes to TERMINATED or OUT TILL FURTHER NOTICE or LEAVE OF ABSENSE or TEMP WORKING OUT OF AREA etc.
In the past I think I had some workbook issues due to that. If I reduce the application so that the rule is applied only to a cell vice the row would that help do you think? Or instead of coloring the entire row maybe just coloring the font in that row?
There's a lot of people to track and CF makes it easy at a glance. But if I can use it with less risk of errors or issues I'd love to.
What do y'all think? And, as always I am extremely grateful for the time everyone takes to read and reply. Thank you.