In general you can use any formula that returns a TRUE/FALSE result, although
there are some limitations, e.g. you can't directly refer to other
worksheets, or use Analysis ToolPak functions are use array constants like
{1,2,3}.

Do you have a specific need?

"romelsb" wrote:

Can anybody tell me other limitations of formula that can be absorbed in a
conditional format window wherein a cell change color based on logical
conditions (e.g. 7 "IF"s,), search functions like lookups, etc....please give
awareness...