Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting

Conditional Formatting

ResolvedVersion 365

Dan has attended:
Excel Intermediate course

Conditional Formatting

How to highlight rows based on one cell of data.

RE: Conditional Formatting

Hi Dan,

Here is the process which you requested

Highlight column of your choice --> Conditional Formatting --> Highlight cell rules --> Duplicate values --> Choose colour of your choice --> Ok --> Conditional Formatting --> Manage Rules --> Highlight full range --> Use a formula to determine which cells to format --> Put in this formula
=COUNTIF(highlight the first column),first cell in that column> 1
--> Ok

For example =COUNTIF($A$3:$A$13,$A3)>1

Regards

Tony

Mon 2 Mar 2020: Automatically marked as resolved.

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.