Conditional Formatting

[Deanomeister]

Hello, first post!

So I'm at a stand still with conditional formatting. My desire is to create a fully automated spreadsheet where the filling of one cell auto populates other columns.

Specifically, I want to format column K,
to where if $b1="text", $k1=$j1-$g1. I do not want to drag a formula all over the place or copy paste a formula every time this needs to happen (this is a manual process that needs to be gone). This should be done without dragging down every time and this should also be done without having formula standing by in cells waiting for other cells to be filled, because it can look untidy. Basically if "text" goes into column b, then the correponding columns in that row auto fill in the value for j1-hg1.

I don't know if I have to use a macro, vba, conditional formatting, if I should be using Access, or what the answer really is for what I'm wanting. I know that conditional formatting can format cells to Colors if it meets the criteria of the formula, but I want it to equal an equation or something specific if it meets the criteria of the formula.

It could be I'm just making a formula incorrectly or applying it to the wrong range for all I know.

Any help on this is appreciated, have a great night every one.

 

[Deanomeister]

Bump

 

[Deanomeister]

Bump

 

[Deanomeister]

Bump

 

[helpneeded04]

The easiest way I can think of is using an if statement. If you put "" in the false portion, the cell will appear to be blank if false and you won't have FALSE or 0. =if($b1<>"",$j1-$g1,"")

 

[Cosmic Wizard]

Hello, first post!

So I'm at a stand still with conditional formatting. My desire is to create a fully automated spreadsheet where the filling of one cell auto populates other columns.

Specifically, I want to format column K,
to where if $b1="text", $k1=$j1-$g1. I do not want to drag a formula all over the place or copy paste a formula every time this needs to happen (this is a manual process that needs to be gone). This should be done without dragging down every time and this should also be done without having formula standing by in cells waiting for other cells to be filled, because it can look untidy. Basically if "text" goes into column b, then the correponding columns in that row auto fill in the value for j1-hg1.

I don't know if I have to use a macro, vba, conditional formatting, if I should be using Access, or what the answer really is for what I'm wanting. I know that conditional formatting can format cells to Colors if it meets the criteria of the formula, but I want it to equal an equation or something specific if it meets the criteria of the formula.

It could be I'm just making a formula incorrectly or applying it to the wrong range for all I know.

Any help on this is appreciated, have a great night every one.

Sorry don't understand: are you saying that if in any cell in column B any text is entered, then the next column will populated with $k1=$j1-$g1.??

Or do you mean that if B1 has text enter into it, then the cell in column K, K1, the formula $k1=$j1-$g1 is then used?

And when you say you want to "...format column K,", is that only when the formula is used, I presume??

Because I would be thinking along these lines:=IF(ISNUMBER(SEARCH("?*",B1)),SUM(J1-G1),"")

That would see if there is text in B1, if so do the formula SUM(J1-G1), or leave blank.

Conditional formatting could then be used to highlight each row if there is a number there: reply back if that what you need!