Conditional Formatting

[Twolf15]

I'm trying to figure out how to do some conditional formatting only if the cell above the cell that I'm formatting has a value. Anybody know how to do this? I know it's probably going to use an IF statement, but I'm having trouble figureing out how IF statements work in conditional formatting.

Example:
Name.....AWT2....AWT3....AWT6.[BLANK CELL]
Dude........X......................X..........

What I'm trying to do is set this worksheet up so that people can add to the row containing AWT tasks without me having to do the conditional formatting for them. So the cells that contain an X should be green (figured that out), and the cells that DON'T contain an X should be red. I figured that out, except then the red cells continue to the right... If I could make it so the red cells don't turn red if there is a blank cell above them, then it would work for what I need.

I hope I explained this well enough...

 

[texasalynn]

not sure I completely understood but your conditional format would be
=A1=""

 

[sijpie]

first condition (for green background): =AND(COUNTA(B3),COUNTA(B4))2nd condition (for red background): =COUNTA(B3)

assuming titles run from B3 right and X's run on B4 right

example here: http://screencast.com/t/7xSR5ytxKi7v

(that is assuming the titles run in line 3 and the X in line 4)