Posted to microsoft.public.excel.worksheet.functions
|
|
if statement syntax help
No need for =True on the end
=AND(G25,I269%)
Works fine
Mike
"M Kan" wrote:
In the conditional formatting wizard, select Formula Is and enter:
=AND(G25,I269%)=TRUE
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
"OfficeManager" wrote:
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?
|