Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on ADJACENT Cells
I know this may sound like a dumb question, but I have values in column A
that I want to have a grey background if their corresponding value in Column B =1. I can't seem to find a way to establish that condition for a cell other than itself! HELP, Please?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on ADJACENT Cells
Hi
No dumb questions here. Select A1 and goto Conditional Formatting Condition1 : Formula is Formula to be entered in the next field: =B1=1 Format as desired. Regards, Per On 6 Jan., 18:56, jayceejay wrote: I know this may sound like a dumb question, but I have values in column A that I want to have a grey background if their corresponding value in Column B =1. *I can't seem to find a way to establish that condition for a cell other than itself! *HELP, Please?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on ADJACENT Cells
click on A1 and Format Conditional Formatting Formula is
=B1=1 and pick a grey background -- Gary''s Student - gsnu200824 "jayceejay" wrote: I know this may sound like a dumb question, but I have values in column A that I want to have a grey background if their corresponding value in Column B =1. I can't seem to find a way to establish that condition for a cell other than itself! HELP, Please?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on ADJACENT Cells
So do I have to Format each cell individually? Cuz I can't get it to work
for a range. "Gary''s Student" wrote: click on A1 and Format Conditional Formatting Formula is =B1=1 and pick a grey background -- Gary''s Student - gsnu200824 "jayceejay" wrote: I know this may sound like a dumb question, but I have values in column A that I want to have a grey background if their corresponding value in Column B =1. I can't seem to find a way to establish that condition for a cell other than itself! HELP, Please?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on ADJACENT Cells
Either use format painter to copy your format down the range, or select the
range before you apply the CF condition. Make sure that your CF condition is exactly as suggested, and that you don't, for example, have an absolute address where you want a relative address. -- David Biddulph jayceejay wrote: So do I have to Format each cell individually? Cuz I can't get it to work for a range. "Gary''s Student" wrote: click on A1 and Format Conditional Formatting Formula is =B1=1 and pick a grey background -- Gary''s Student - gsnu200824 "jayceejay" wrote: I know this may sound like a dumb question, but I have values in column A that I want to have a grey background if their corresponding value in Column B =1. I can't seem to find a way to establish that condition for a cell other than itself! HELP, Please?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Non-Adjacent Columns | Excel Worksheet Functions | |||
Conditional Formatting Based on Value of Adjacent Cell | Excel Discussion (Misc queries) | |||
Conditional Formatting for adjacent cells | Excel Discussion (Misc queries) | |||
conditional formatting adjacent cells | Excel Worksheet Functions | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) |