Conditionally formatting a range based on a specific cell's value

Question

I have the below table:

A1=100

Company     A     B     C  .........
Microsoft   134   51    91
Google      14    532   215
Samsung     1     111   133
.
.
.

I wish that only the values that are greater than A1 will be highlighted in green.

EDIT: this question, although looks very similar, do not solve the problem above.

possible duplicate of [Google Spreadsheet Conditional Formatting Based on another Cell Value](http://stackoverflow.com/questions/20545961/google-spreadsheet-conditional-formatting-based-on-another-cell-value) — aucuparia, Sep 29 '15 at 12:35
RoyEsh, it would help if you'd [edit] your question to explain WHY that other answer does not apply to your situation. — Mogsdad, Sep 30 '15 at 20:27

score 1 · Answer 1 · answered Sep 29 '15 at 18:42

1

Please select entire sheet, Format, Conditional formatting..., Format cells if..., greater than:

=$A$1

select green and Done.

answered Sep 29 '15 at 18:42

pnuts

1 Answers1