View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aimee209 aimee209 is offline
external usenet poster
 
Posts: 18
Default Specific range formating

I have a sheet where I only want the code to effect certain parts of rows
(ie. D6:G6, D10:G10, D14:G14, etc). I want to apply conditional formatting.
The CF function only allows 3 conditions, and I need 4 so I thought I would
try it with VBA.
I want to look at each of the cells in the specified ranges and if it's
greater than 95, a certain color, between 90 and 95 another color, less than
90 a different color and if the cell has "N/A", to be black.

Thanks!