[mothclass]

I have an excel spreadsheet with lots of dates on it.  One time, I saw someone create an arrow or bar that automatically went to today's date on the spreadsheet, so a person would not have to scroll down through past dates to get to today's date.  I tried to " create a new rule" in conditional formatting so that today's date was highlighted yellow.  The highlighting feature works, but when I open the spreadsheet I am not taken automatically to today's date.  Is that some other feature? Can it be done on the excel in google drive? 

[Advertisements]

How to Use Conditional Formatting in Excel?

 

Conditional formatting is used to pick out important data from a huge list of data. Though it is a little difficult to use, knowing the basics can help us in whatever project we are working on.

We can use conditional formatting in many ways. Following are the two ways of using conditional formatting.

1 Conditional Formatting in Same Cell

2 Conditional Formatting in Multi Cell

3 Enter the number in the box provided for “Format cells that are GREATER THAN:”, and select ‘Custom Format’.

4 Select Fill from Format Cells, Select a required color from Background color and select OK.

5 The picture shows the result after applying Conditional Formatting

 

Excel Consultants

[krishnap2w2]

How to Use Conditional Formatting in Excel?

 

Conditional formatting is used to pick out important data from a huge list of data. Though it is a little difficult to use, knowing the basics can help us in whatever project we are working on.

We can use conditional formatting in many ways. Following are the two ways of using conditional formatting.

1 Conditional Formatting in Same Cell

2 Conditional Formatting in Multi Cell

3 Enter the number in the box provided for “Format cells that are GREATER THAN:”, and select ‘Custom Format’.

4 Select Fill from Format Cells, Select a required color from Background color and select OK.

5 The picture shows the result after applying Conditional Formatting

 

Excel Consultants