Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Conditional formatting based on another column.

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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Conditional formatting based on another column.

Try a formula of

=ISBLANK(A1)

--
HTH

Bob

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

"Rob White" wrote in message
oups.com...
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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Conditional formatting based on another column.

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!
================================================== ===



"Rob White" wrote in message
oups.com...
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.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Conditional formatting based on another column.

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

Regards,

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

"Bob Phillips" wrote in message
...
Try a formula of

=ISBLANK(A1)

--
HTH

Bob

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

"Rob White" wrote in message
oups.com...
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.




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default Conditional formatting based on another column.

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...

-----------------------------------------------------------------------
"Rob White" wrote in message
oups.com...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting based on entire column mike Excel Worksheet Functions 7 February 6th 07 11:40 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 3 January 20th 07 03:02 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 0 January 15th 07 05:35 PM
Conditional Formatting Based on If and Or luvthavodka Excel Discussion (Misc queries) 5 August 10th 06 10:13 PM
conditional formatting based on column snax500 Excel Discussion (Misc queries) 4 April 27th 05 06:13 PM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"