lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
Lets say that i have a big sheet with many rows and columns. Similar to the table below. Lets say I have 10000 rows and 100000 columns. Lets say I want to highlight cells which has value >50. So do I need to select all the number in the table and then go to conditional formatting and select Greater than rules. Is there better way? Selecting all numbers is not practical. It is possible to select cell B2 and apply conditonal formatting on it and then "somehow" I ask excel to do the same formatting to other numbers? Thank you very much
Lets say that i have a big sheet with many rows and columns. Similar to the table below. Lets say I have 10000 rows and 100000 columns. Lets say I want to highlight cells which has value >50. So do I need to select all the number in the table and then go to conditional formatting and select Greater than rules. Is there better way? Selecting all numbers is not practical. It is possible to select cell B2 and apply conditonal formatting on it and then "somehow" I ask excel to do the same formatting to other numbers? Thank you very much
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | name | jan | feb | mar | ||
2 | jack1 | 19 | 94 | 47 | ||
3 | mary1 | 29 | 50 | 90 | ||
4 | jack2 | 52 | 4 | 82 | ||
5 | mary2 | 30 | 88 | 36 | ||
6 | jack3 | 7 | 70 | 74 | ||
7 | mary3 | 25 | 97 | 72 | ||
8 | jack4 | 58 | 30 | 88 | ||
9 | mary4 | 30 | 83 | 69 | ||
10 | jack5 | 35 | 9 | 58 | ||
11 | mary5 | 61 | 32 | 13 | ||
12 | jack6 | 96 | 54 | 13 | ||
13 | mary6 | 70 | 38 | 95 | ||
14 | jack7 | 11 | 86 | 16 | ||
15 | mary7 | 31 | 63 | 70 | ||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B2 | Cell Value | >50 | text | NO |