Thread: Using VBA: Extending limits of Conditional Formatting
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Using VBA: Extending limits of Conditional Formatting
One way:

In Mike's code, instead of

Target.Interior.ColorIndex = x

use

Target.EntireRow.Interior.ColorIndex = x



In article ,
Chris Pederson wrote:

Hi Mike I'm having a simular problem but I need an entire Row to change
color to change as a result of the value of one cell is there way to do
this using this VBA?
Reply With QuoteReply With Quote