Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting based on entire column | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting Based on If and Or | Excel Discussion (Misc queries) | |||
conditional formatting based on column | Excel Discussion (Misc queries) |