Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for adjacent cells
Hello,
I am trying to setup conditional formatting for some adjacent cells in my worksheet. For example is it possible to apply conditional formatting to cell B2 when cell A2 meets the criteria you are looking for? -- Drew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for adjacent cells
Yes, refer to A2 column absolutely, that is $A2
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Drew" wrote in message ... Hello, I am trying to setup conditional formatting for some adjacent cells in my worksheet. For example is it possible to apply conditional formatting to cell B2 when cell A2 meets the criteria you are looking for? -- Drew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting 2 cells | Excel Worksheet Functions | |||
Conditional Formatting based on other cells | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |