M
Maver1ck666
Okay, I have a spreadsheet with over 1000 lines of data in all at different
status' of progress.
What I would like to do it to highlight the whole line a certain colour
depending on the status value.
I currently have the max 3 conditional formats doing this but I need to
expand them and there are over 10 different status'.
My spreadsheet runs from A to L (with the status being I). Is there any way
the formatting could loop to check the whole spreadsheet?
Thanks in advanced for your help.
Maver1ck666
status' of progress.
What I would like to do it to highlight the whole line a certain colour
depending on the status value.
I currently have the max 3 conditional formats doing this but I need to
expand them and there are over 10 different status'.
My spreadsheet runs from A to L (with the status being I). Is there any way
the formatting could loop to check the whole spreadsheet?
Thanks in advanced for your help.
Maver1ck666