conditonal formatting

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi,

I am trying to create a conditional statement and am
wondering if anyone can help me.

Here is what I have so far.

YTD statement which keeps a running balance of the
numbers entered in column "Actual" in 'T&E' based on
whether the month in worksheet 'House Keeping' has an x:
SUMIF('House Keeping'!$B$19:$B$30,"x",'T&E'!D6:D17)

I want the running balance to be populated with
forecasted numbers (located in a different column) and as
actual numbers become available, it would get inputted
into the cells which would change the background of the
cells to a different color; otherwise the background will
be yellow if all I have is the forecast number.

Thanks.
 
Hi
first: your SUMIF statement does not look correct for me
(diffferent ranges)?. But for formating a filled cell with
a different color try:
- select your cells (e.g. cells B1:B20)
- goto 'format - Conditional Formating'
- enter the following formula
 
Frank,

I went ahead and sent you a sample worksheet of what I'm
trying to do--which is pretty hard to describe here.

Thanks for any help you can provide.

Michael
 
Back
Top