Thread
:
Help with a formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
Posts: n/a
Help with a formula
Yes: as it is a function the format is AND(condition1,condition2 etc).
So in your case the formula would be:
AND(A2="AST",A3="Y")
then set your format for the cell.
Hope this helps.
Pete
Reply With Quote