Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
G'day Everyone
Dare I say it, but I've hit the proverbial brick wall here due to a long absence AFK & Excel (2007).. Specific work Range = $A3:$L100 The target Column with the Cell value question is "I" eg =IF($I328,$A3:$L3="BOLD"),0.....or something along those lines So essentially, if any cells in Column "I" is 28, the Rows along that specific intersect will all become "Bold" Thx heaps in advance Regards Rusty OL' Buzzard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi
Place cursor in cell I3. In the Home tab click 'Conditional formatting'. Click new rule, then select 'Use a formula to determine wich cells to format'. In the window 'Format values where this formula is true:' enter the formula =$I328 Now copy cell I3 and 'paste special' - 'formats' into your range of cells $A3:$L100 Hope this helps "NoodNutt" wrote: G'day Everyone Dare I say it, but I've hit the proverbial brick wall here due to a long absence AFK & Excel (2007).. Specific work Range = $A3:$L100 The target Column with the Cell value question is "I" eg =IF($I328,$A3:$L3="BOLD"),0.....or something along those lines So essentially, if any cells in Column "I" is 28, the Rows along that specific intersect will all become "Bold" Thx heaps in advance Regards Rusty OL' Buzzard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Whoops!
Forgot - after entering the formula select the format you require eg Bold "NoodNutt" wrote: G'day Everyone Dare I say it, but I've hit the proverbial brick wall here due to a long absence AFK & Excel (2007).. Specific work Range = $A3:$L100 The target Column with the Cell value question is "I" eg =IF($I328,$A3:$L3="BOLD"),0.....or something along those lines So essentially, if any cells in Column "I" is 28, the Rows along that specific intersect will all become "Bold" Thx heaps in advance Regards Rusty OL' Buzzard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |