Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to format a cell as a condition of an other?

Expl. Format Cell A1 if Cell A2 meets certain criteria.
 
Select cell A1 then Format | Conditional Formatting. In the dialogue
box select "Formula Is" rather than "Cell value is" then you can enter
a formula relating to cell A2, eg

A2>10

Click the format button and the patterns tab and choose a colour to
highlight the cell. Click OK twice.

Now the background colour of A1 will change if the contents of A2
exceed 10.

Hope this helps.

Pete
 
Back
Top