ISBLANK to keep same formatting

[DCecil07]

All gurus,

I have a spreadsheet with data and has rows being used as a section header sort of thing that is filled with a light green color. What I am trying to do is apply a formula to an entire column that keeps the cell in that light green row to be blank.

With this formula....

=IF(ISBLANK(F3)," ",VLOOKUP(D3,'V:\NEPD Quality\David Cecil\[PlanloadCodes.xlsx]Codes'!$A$1:$B$28,2,FALSE))

The formula works great but the problem is that the cells that are blank are in the light green shaded row. When that formula is applied to those rows, it removes the green and makes the cell white. How can I keep the same formatting for those cells that are green.

What are my options?

 

[DCecil07]

Really need something fast....Need to get this turned over soon. PLEASE HELP!!!

 

[Murali1881]

Please paste the formula with

Paste Special > Formulas.

Thanks & Regards,

Murali

 

[Jonmo1]

Perhaps change
" "
to
""

 

[DCecil07]

I'm in a meeting right now but I will test that out when I get back to my desk. Thanks for the replies.