View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wood Grafing Wood Grafing is offline
external usenet poster
 
Posts: 57
Default Increase number of conditional format arguments

You can't with the default conditional formatting, but you can 'trick' it
into letting you use more. Check this out:
http://www.mcgimpsey.com/excel/conditional6.html

"Alison" wrote:

Is there any way to increase from "3" the number of conditional format
arguments allowed?

I have 4 arguments and the cells this applies to will contain one of the 4
arguments or be blank. If the cell is blank, no conditional formatting
should be applied. For each of the 4 arguments, a different cell pattern
colour would be applied.

Thanks!