Conditional formatting on big sheet

[lezawang]

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

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

 

[Fluff]

You could set the rule for B2 & then use the format painter, but you would still need to select the cells.

 

[kweaver]

Try using the GOTO command to select the large range of data.

 

[Marc L]

Hi,​

​

as the drawback of using conditional formatting is that makes a big sheet so heavy, may slow down its use …​