Can conditional formatting have more than three conditions? If so how?
I have five possible values coming from a very large vlookup table. I would like to have a separate color for each of the five.
The tables are already formatted correctly, so is it possible to bring the formatting over with vlookup?
Using:
=IF(ISNA(VLOOKUP(H27,AI1:AJ1000,2,0)),"",VLOOKUP(H27,AI1:AJ1000,2,0))
Thank you!!!
I have five possible values coming from a very large vlookup table. I would like to have a separate color for each of the five.
The tables are already formatted correctly, so is it possible to bring the formatting over with vlookup?
Using:
=IF(ISNA(VLOOKUP(H27,AI1:AJ1000,2,0)),"",VLOOKUP(H27,AI1:AJ1000,2,0))
Thank you!!!