View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default if statement syntax help

Try this...

Select cell D2
Goto the menu FormatConditional formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=AND(COUNT(G2,I2)=2,G25,I269%)

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"OfficeManager" wrote in message
...
I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm
assuming
I can use conditional formating for that, but how do I write it?