i want to use conditional formatting based on another cell

[Elainefish]

if A1 is not equal to 6
G100 will turn to RED

[Special-K]

Select G100

Conditional Formatting
New Rule
Use a formula to determine...

=(A1<>6)
format as red

Use Format painter (paintbrush icon) to copy to other cells

[Fotis1991]

In Conditional format rules of G100, use this.

Please Login or Register  to view this content.

choose format. Click ok.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.