Share via

Excel formula

BABY_JOJO 241 Reputation points
2022-12-30T06:47:42.167+00:00

The four columns of A, B, C, D are highlighted in red if the values of a row are all the same

For example, if A2:D2 and A10:D10 have the same content, both rows are highlighted in red.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,752 questions
0 comments
Accepted answer
  1. Emi Zhang-MSFT 27,391 Reputation points Microsoft Vendor
    2022-12-30T07:29:46.02+00:00

    Hi @BABY_JOJO ,
    Select the Range and go to Home- Conditional Formatting- New rules...- Use a formula to determine which cells to format- enter the formula and set the cell format to fill Red: 

    =SUM(--($A1:$D1=$A$1:$D$10))>4

    274975-image.png

    Hope it's helpful.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.