Conditional Formatting - "Applies to"

[lawi227]

I am trying to apply condition formatting to select cells; they are not in consecutive rows.

Can I use the "Applies to" field? I tried to enter in the "applies to" field: E4,E5,E7,E8,E9,15, but it didn't work.

 

[hotabae]

Did you try Ctrl + clicking the cells to highlight the ones that are required?

Otherwise, it would seem the format the "Applies to" is looking for would be this:

=$E$4,$E$5,$E$7,$E$9,$E$15

(how it autofills)

or

=E4,E5,E7,E9,E15

​

(this works too)

Remember to include the "=" sign at the beginning

 

[lawi227]

I had to manually do 1 cell at a time. Meaning I selected one cell to add to the list, and then clicked enter/okay and saved. Then I went back and added the next cell.

Is there a limit to the number of cells you can do this to? I added conditional formatting to 4 of them and it wont let me do any more.

Did you try Ctrl + clicking the cells to highlight the ones that are required?

Otherwise, it would seem the format the "Applies to" is looking for would be this:

=$E$4,$E$5,$E$7,$E$9,$E$15

(how it autofills)

or

=E4,E5,E7,E9,E15

​

(this works too)

Remember to include the "=" sign at the beginning

 

[hotabae]

It looks like there are some limitations like that on earlier versions of Excel. What version are you currently using?

Seems like 2003 had a lot of limitations and 2007 had a few limitations.