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

Printing from Word my Inserted Pictures colors are dull and lack color 0
Conditional formatting dates 3
Conditional Formatting Based on Due Dates 3
Need help modifying code 0
conditional format of entire row based on a single cell in row 7
format 1
Excel 2010 Conditional Formatting 2
Excel does not accept text format! 0

Top