Thread: Conditional Formatting 4+ conditions, format rows based on cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Driscol[_2_] Mark Driscol[_2_] is offline
external usenet poster
  
Posts: 75
Default Conditional Formatting 4+ conditions, format rows based on cell
See if posts like this one may help you. Using the Select Case or If
ElseIf statements can work for this.

http://groups.google.com/group/micro...10e43923f1e09e

Mark


nockam wrote:
I am trying to come up with a way through VBA to conditionally format a
row based on one cell within that row. I can do this just fine through
conditional formatting with 1-3 criterias but i need to do it for 5.
Can anyone help me out? I need to say something like if cell A1 = This
then color row 1 ____

Thanks,

Garrett


--
nockam
------------------------------------------------------------------------
nockam's Profile: http://www.excelforum.com/member.php...o&userid=15744
View this thread: http://www.excelforum.com/showthread...hreadid=556271

Reply With QuoteReply With Quote