I have a section of a sheet where I only want certain data to display based on other data in the sheet. So, I am using "IF" statements. This works fine except that I would like a portion of the data surrounded by a box (Cell borders) and a portion is a column of numbers that are summed up so I also want a double underline at the bottom.
If I format the cells to create the borders and the double underline, then the borders exist even when no data is there.
How do I tie these formatting choices to an "IF" statement?
Thanks OH GREAT EXCEL WIZARDS.
JPF
If I format the cells to create the borders and the double underline, then the borders exist even when no data is there.
How do I tie these formatting choices to an "IF" statement?
Thanks OH GREAT EXCEL WIZARDS.
JPF