Scribd
Upload
11 views2 pages

Practice File3

The document lists various houses for sale, detailing their prices, locations, number of bedrooms, and bathrooms. It includes notes on using conditional formatting to highlight data and identify top listings. The focus is on visualizing the highest values among the properties listed.

Uploaded by

Caloy Celoy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views2 pages

Practice File3

The document lists various houses for sale, detailing their prices, locations, number of bedrooms, and bathrooms. It includes notes on using conditional formatting to highlight data and identify top listings. The focus is on visualizing the highest values among the properties listed.

Uploaded by

Caloy Celoy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

House

Listing Price
TownSquare Bedrooms
Feet Bathrooms jojo notes:
House1 ###Fayetteville2,580 4 2 1 Selecttrange and choose your format
House10 ### Dewitt 1,580 4 3 2 CTRL +home
House100### Dewitt 2,345 3 2 3 Conditional formatti
House101###Jamesville2,425 4 2 4 Conditional formattin
House102### Cicero 2,505 3 1 top 10% meaning,
House103###Fayetteville2,585 2 3
House104### Camillus 2,665 3 2 jojo notes: conditional formatting is helping us to find som
House105### Manlius 2,745 4 2
House106### Dewitt 2,825 3 2
House107###Jamesville2,905 4 3
House108### Cicero 2,985 3 3
House109###Fayetteville2,685 4 2
House11 ###Jamesville1,660 4 4
House110### Camillus 2,745 4 3
House111### Manlius 2,805 4 4
House112### Dewitt 2,865 3 2
House113###Jamesville2,925 3 2
nge and choose your format
This is shortcut to return to A1 cell
this is for viosualization only so you can see immediately the largest number
this is the same in data bars for visual only
if you have 10 item then multiply to 10% is 1, then select only 1 item which is the most highest.

ditional formatting is helping us to find something based on your condition and then highlight in the cell

You might also like