LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default Dynamically setting CELL COLORS based on TWO OTHER cell values

Excel 2003 SP3

I'd like to set the background cell color based upon the concurrent values
of two (2) cells.
Let's say that Column A has the day of the week and Column D and Column E
have various calculated values based upon the data in Column C (measured
data).
So, if cell D10 has a calculated value of "B" AND cell E10 has a calculated
value of "B" then I'd like for A10 (day of week) to be filled with a
background color of, say, green.
However, if cell D10 has a calculated value of "S" AND cell E10 has a
calculated value of "S" then I'd like for A10 (day of week) to be filled with
a background color of, say, red.
All other combinations would leave the background color of cell A10 as-is
(standard white).
How can I do this as the Conditional Formatting doesn't work since this is
referencing other (external) cells.
TIA!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically setting worksheet tab colors John Excel Worksheet Functions 4 January 29th 09 06:55 PM
Automatically change cell colors based on date in cell Greg Excel Discussion (Misc queries) 2 January 27th 09 05:55 PM
MY 2003 Excel does not show cell colors. Solution? Setting? WetRiverOak Excel Discussion (Misc queries) 1 August 2nd 06 04:21 AM
Store values of a dynamically changing cell Yogesh Excel Worksheet Functions 0 August 4th 05 06:40 PM
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 05:21 PM


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"