Conditional formatting based on another column.

[Rob White]

I have a column that I need a format applied to depending on the value
of another column, specifically if values in column A are not blank
then I want the values in column B to have some formatting applied.
E.g.

A B
1 Formatted
Not Formatted
3 Formatted
2 Formatted

I have the formatting applied everywhere else, but I just can't quite
seem to get the formula right. I'm almost starting to wonder if I have
to do it on a cell by cell basis, but that would be impractical as I
have no idea how many rows are going to be entered (probably 100's).

Thanks for any help.

 

[Bob Phillips]

Try a formula of

=ISBLANK(A1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[RagDyeR]

Select Column B, where the focus is in B1 (colored white), then:
<Format> <Conditional Format>
Change "Cell Value Is" to "Formula Is", and enter this:

=A1<>""

Click on "Format", and choose the settings you prefer.
Then <OK> <OK>
And you're done!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



I have a column that I need a format applied to depending on the value
of another column, specifically if values in column A are not blank
then I want the values in column B to have some formatting applied.
E.g.

A B
1 Formatted
Not Formatted
3 Formatted
2 Formatted

I have the formatting applied everywhere else, but I just can't quite
seem to get the formula right. I'm almost starting to wonder if I have
to do it on a cell by cell basis, but that would be impractical as I
have no idea how many rows are going to be entered (probably 100's).

Thanks for any help.

 

[RagDyeR]

Did I read it wrong, or did you?<bg>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Try a formula of

=ISBLANK(A1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Earl Kiosterud]

Rob,

Debra Dalgleish has a bunch of info on that. http://contextures.com/xlCondFormat01.html

The secret is to select the cells that are to have the formatting, note the active (white)
cell of your selection, then put in a formula that relates to the active cell. That formula
will refer to the cell(s) that determine if the formatting is to be applied. It must be a
boolean -- must resolve to TRUE or FALSE. The formula will be different in different cells
of the selection, as it's effectively copied into the conditional formatting of the other
cells of the selection. The cell references, if not absolute (dollar signs), will have
changed.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...