0
You just need to be able to reference the other sheet, which you do with the sheet name, an exclamation mark and a cell reference. So in a cell on Sheet2, you could have a formula referencing cell A3 on Sheet1 that could be something like:
=IF(Sheet1!A3>50, "Over 50","50 or Less")
Add your answer:
Earn +20 pts
How do you remove a conditional format from your excel worksheet?
Format, conditional formatting, delete, tick the relevant boxes and click delete.
What is a type of formatting that changes the appearance of cells in an Excel worksheet based on a condition or criteria is called?
Conditional Formatting.
What is worksheet in ms excel?
It is another name for spreadsheet. It is a single tab.
What is a another name for an excel file?
spreadsheet file or workbook
How can a chart be moved to another worksheet in Excel?
Right-click on the chart - then either Cut or Copy and Paste in other worksheet
What is an Excel worksheet?
A worksheet is a single page in a workbook.
What is the new of a new worksheet in Excel?
Create a blank worksheet.
What is Microsoft Excel and other commonly used term in Excel?
Workbook Worksheet Vlookup Index Pivot Conditional formatting Table Sort Filter Cells Rows Columns are most common terms used in MS Excel Regards, Sarfaraz Ahmed http://findsarfaraz.blogspot.com
Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another in the workbook?
Worksheet
Is Excel chart created from selected worksheet data?
Yes, a chart in Excel is created from data that has been selected in the worksheet.
Is in excel like a notebook?
worksheet
What is like a notebook in excel?
worksheet
