Conditional Formatting

[NoodNutt]

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($I3>28,$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

 

[T. Valko]

Try this...

Assuming there is no TEXT in I3:I100

Selet the *entire* range A3:L100 starting from cell A3. A3 will be the
active cell. The active cell is the one cell in the selected range that is
not shaded.

Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
=$I3>28
Click the Format button
Select the Font tab, select Bold
OK out

 

[David Biddulph]

CF/ Formula Is:
=$I3>28
Select your bold format

 

[NoodNutt]

Thx Heaps guy's

PS

Oops! I accidentally double posted this topic, sorry everyone..

Cheers

 

[T. Valko]

You're welcome!