Thread: Conditional Formating??
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
tony h
 
Posts: n/a
Default Conditional Formating??

I think you need an additional column on which to base the flag if the
new column is B set the first value to true then a formula of
=IF(A2=A3,B2,NOT(B2)) use this result to drive the conditional
formatting

hope this helps. I suspect there is a cleaner way.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=533936

Reply With QuoteReply With Quote