I have an Excel sheet with some data, I never know how many debs/loan the person have. It could be all from one to two hundred or even more...
I'm trying to look in column I if the cell has N/A in it, if so set the font to be in red, if not, it should be white.
If I try this code: =$I4="N/A" I' get 4 in red, not the actual row that has N/A in it, as it is now, it should be row 7 that gets the red font.
How can I solve that problem? I'm not really feel like doing a new rule every time the user adds a post.
As it is now I have a listener witch triggers and macro to put in the formulas into the proper cell and row.
I'm trying to look in column I if the cell has N/A in it, if so set the font to be in red, if not, it should be white.
If I try this code: =$I4="N/A" I' get 4 in red, not the actual row that has N/A in it, as it is now, it should be row 7 that gets the red font.
How can I solve that problem? I'm not really feel like doing a new rule every time the user adds a post.
As it is now I have a listener witch triggers and macro to put in the formulas into the proper cell and row.