View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
richzip richzip is offline
external usenet poster
 
Posts: 74
Default Multiple conditional formats

I need help with conditional formatting. Basically I want to compare the
values in 3 cells, and have the special format apply to the highest value. I
have 2 problems:

1. I found out how to do conditional formatting, and to set up multiple
conditions. But, it seems this is an "or" instead of an "and" function. I
need the cell to be formatted if it meets both conditions (i.e. greater than
the values in both cells it is being compared to)

2. When I go to conditional formatting, I can only change the font style.
Font size is "greyed out", and there is no option to highlight the cell a
specific color.