Hello,

First time posting in this forum. I have a question over some conditional formatting. I am wanting to format my cells that if they are within 25% of a certain number than they turn into an "x"; if they're not, it's blank. For example, Let's say I'm basing everything off of cell B2, than B3 would be an "x" if it is within the range (B2)(.75)<B2<(B2)(1.25). If it's outside this range, it'd be blank, or a " ". This rule would apply to all cells in column B. I know this will have to be built off of a new rule where I would have to use a formula to determine which cells would be formatted, but I'm not sure which formulas to use, if I would have to have an IF function, or a combination of IR OR's. If anyone has any insight, please let me know. Thank you.

-avannoord