Conditional Formatting

Twolf15

New Member
Joined
Mar 7, 2011
Messages
7
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...
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
not sure I completely understood but your conditional format would be
=A1=""
 

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
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)
 

Forum statistics

Threads
1,141,843
Messages
5,708,922
Members
421,598
Latest member
NewHere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top