Conditional formatting by merged cells

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
8,093
Office Version
2019
Platform
Windows
No, it's an index position. You can have multiple rules for the same range with conditional formatting, the (1) is saying that this is to work with the first condition for the range.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,090,241
Messages
5,413,266
Members
403,468
Latest member
GRamos

This Week's Hot Topics

Top