Y
yigalb
I try to auto-color certain values - and I did it with conditional
formatting. Why cant I add 4th and 5th conditions ?
formatting. Why cant I add 4th and 5th conditions ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
M
Myrna Larson
Because Microsoft didn't program it to handle more than 3.
F
Fred Smith
Why are there any limits in Excel (rows, columns, etc.)? Because it's very
difficult to program for an infinite number of entries. So all companies,
Microsoft included, walk the fine line of matching the cost of a feature to
the expected revenue. They typically will provide features to the 95th
percentile. Based on the small number of people who have requested more than
three conditions in conditional formatting, I'll bet they met their
objective.
difficult to program for an infinite number of entries. So all companies,
Microsoft included, walk the fine line of matching the cost of a feature to
the expected revenue. They typically will provide features to the 95th
percentile. Based on the small number of people who have requested more than
three conditions in conditional formatting, I'll bet they met their
objective.
J
JE McGimpsey
If your entries are numeric you can get up to 6 font color conditions:
http://www.mcgimpsey.com/excel/conditional6.html
http://www.mcgimpsey.com/excel/conditional6.html