View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default 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