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?
|