The above video goes away if you are a member and logged in, so log in now!

 Would you like to get all the newest Gaming News fromQJ.NET in your email each day? Want to learn more about the team who brings you the QJ news?

## Excel Question.

This is a discussion on Excel Question. within the Everything Windows forums, part of the General PC Forums category; how would i make it so that if a cell(say h22 for the example) is a specific number(27) the whole ...

 Tweet
1. ## Excel Question.

how would i make it so that if a cell(say h22 for the example) is a specific number(27) the whole sheet changes. Basically I want conditional formating that affects the whole sheet, but only relys on 1 or 2 cells for the conditional formating. on 2007 if it maters.

2. Like using formulas....?

3. when referencing that cell in the sheet place a \$ in front of the row and column. Like \$a\$27

4. yes
-= Double Post =-
Originally Posted by b2p1mp
when referencing that cell in the sheet place a \$ in front of the row and column. Like \$a\$27
so I would select the whole sheet and set up formating, and for the condition say \$a\$27=30? also I fail to see how an absolute reference would help.

5. well the absolute reference is how you would use a cell outside of the data area, once you reference the cell in the data sheet manually once, then you can drag the formula down and the absolute reference will be helpful.

6. What exactly are you trying to do?

7. Im making a "who is this" quiz(blurred faces, guess who they are) the formulas are IF(A3="","",IF(A3="Joe"," Correct","Incorrect")) the formula may be a little of as its from memory, and for my score keeping I plan to use COUNTIF(A1:J40,"Correct") the score can go to 30, so my plan is to make the whole sheet go red(or other formating) if the score is 30.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

All times are GMT -8. The time now is 05:06 PM.

Use of this Web site constitutes acceptance of the TERMS & CONDITIONS and PRIVACY POLICY