Conditional format stoplight based on worst color

M

Morgimo

Can you conditionally format based on a color? I want each row's stoplight
color (green, yellow, red) to change based on the worst color in that row.
All the colors in the row are conditionally formated and will change as dates
are entered or changed.
 
G

Gord Dibben

How would Excel determine the "worst color"?

My wife hates red and I'm not too fond of most pastels.

Your preferences may differ.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Based on Due Dates 3
summarizing conditional formats 5
conditional format of entire row based on a single cell in row 7
format 1
Conditional Formatting on Color 4
Conditional Format - 3 conditions 3
Conditional format a column based on value in a different column 3
conditionally formatting 3

Top