Dynamically setting CELL COLORS based on TWO OTHER cell values

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

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!
 
hi
select A10.
on the menu bar>format>conditional fomating
condition 1 = formula is......=AND(C10="B",E10="B").....green
condition 2 = formula is......=AND(C10="S",E10="S").....red

Regards
FSt1
 
Thanks! Worked!!!

FSt1 said:
hi
select A10.
on the menu bar>format>conditional fomating
condition 1 = formula is......=AND(C10="B",E10="B").....green
condition 2 = formula is......=AND(C10="S",E10="S").....red

Regards
FSt1
Click to expand...
 
If The Formuals Are Dates

Please could you let me know how this may be applied to dates. For example there is a target date (column x) and if column y has not been filled with a date and the original date (x) has arrived or passed then it is flagged and turns red. Is this possible?
 
Back
Top