Advanced Excel

Hi Crystal,

Thank you for your question.

Let's say there is a column filled with inconsistent formulae and you want to add the format on a particular formula. Let say we will highlight the formula =A1*2, you can do the following:

1) Highlight the 1st cell with the formula, select Format menu > Conditional Formatting

2) Select: Box1 Cell Value Is
Choose: Box2 equal to
Type: Box3 =A1*2
do not use absolute referencing $

3) Click Format and pick the colour you want

4) Click OK

Use the Format Painter (brush) to copy this condition down the entire column of formulae.

See if that helps.

Kind regards,

Katie Woo
Microsoft Certified Trainer