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

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

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