Sleeper: Conditional format

[austenr]

I need to find a way to use conditional formatting or something that when a condition is met make the text in the cells white. Ordinarily this would not be a problem but most of the cells have thin black borders on them. How do you deal with them?

[Bob Phillips]

What does the black border have to do with the text colour?

[Simon Lloyd]

The condition you're thinking of would help , when you say black lines do you mean the border? Right click>format cells>borders and click none, or do you mean the grid as it stands? menubar>options>display and uncheck show gridlines

[austenr]

WhAt I Am saying is I want everything in that cell range to be inviIble

[austenr]

trying to come up with a formula in conditional formatting that will do the following on the attached WB:

remove the border in A1, remove the fill color in D5 and make the text white in E2.

[Bob Phillips]

I think that you need to set the gridlines colour to a known (to you) colour, and then set the border to that colour in the CF.

[austenr]

What would the formula look like?

[Bob Phillips]

The formula is irrelevant Austen (to this discussion, it would depend upon what data would drive hiding the borer, which only youy know), but is all in the formatting.

[austenr]

Bob,

Have multiple ranges of cells to do hiding of border colors(automatic), cell text color(automatic). The data that drives the formatting is the value contained in

Sheets("Sheet2").Range("E4")

Sorry to be so dense and maybe not explaining it well. All I want to do if the condition is met is to have the cells look like any ordinary blank cell.

What I am really wanting to find out is how to format multiple ranges of cells as described above if the condition is met. In other words, in the conditional formatting would I choose value is, or do I need to construct a formula to do all ranges simultaneously?

[austenr]

Never mind I think I got it.