CODEWITHSUNDEEP
google-sheets
pmichna
pmichna

Reputation: 4888

Google spreadsheet custom conditional formatting

I have a table like

    A   B   C   D
   --------------
1 | 3   2   4   1

I want to highlight the max value in the row. I tried to apply a custom conditional formatting formula, but I got stuck. Something like =A1=MAX(A1:D1) doesn't work. I need to substitue somehow A1 with "current" cell but I don't know how.

Upvotes: 1

Views: 97

Answers (2)

pnuts
pnuts

Reputation: 59440

Interpreting the requirement in a different way. Select ColumnsA:D, Format, Conditional formatting..., Custom formula is:

=A1=max($A1:$D1)

with formatting of your choice.

Upvotes: 0

JPV
JPV

Reputation: 27242

Try:

=$A$1:$D$1=max($A$1:$D$1)

and see if that works..

Upvotes: 3

Related Questions