Multiple conditional formatting

  • Thread starter Thread starter soltek
  • Start date Start date
S

soltek

I have a column for "S" or "D" (server or dekstop)
servers are a max 5 day build time. desktops are max 2 day build time.
I have a column that calculates the time from order entry to shippin
date. How can I conditional format this column of counted days, t
specify one color if a server is past 5 days, or another color if
desktop is past 2 days?? Thanks in advance -Te
 
been there, done that, not bakin my cookies man. If d5="S" and B5 i
greater than 5, B5 needs to be shaded blue. Likewise, if D5="D" and B
is greater than 2, it needs to be shaded red.....still stuck in th
Shir
 
Hi
- select cell D5
- goto the conditional format dialog
- choose formula and enter the following formula:
=(D5="S")*(B5>5)
- choose the blue color

for the other condition enter the formula
=(D5="D")*(B5>2)
 
Well, I have tried
(U7:U1000="D")*(S7:S1000>5)
and this does not work. If a cell in column U is labeled with a "D
for desktop, and the number of days to build in column S is over
days, I want conditional formatting to change the cell to red. Anybod
got anything on this. It seems to pick up a few random cells in thi
formula, but nothing is consistant with these arguments
 
Hi
it can't work :-)
So select cells D7:D100 for example. and the enter the formula:
=(U7="D")*(S7>5)

Excel will adapt the row references automatically
 
I am in COMPLETE agreeance with you in that, although when I do ente
that function, it does not work either. I have checked all my cel
formatting and stuff but it just doesnt seem to work for me.... ;-
 
Hi
have you tried this for a single cell first?. Just select one cell
(e.g. D7) and try it.
 
Back
Top