formatting based on a condition

paulrus

New Member
Joined
Apr 14, 2002
Messages
15
Can anyone give me an example of how to format a ROW based on a formula? For example - if cell E6= "FL" then shade the entire row 6 Green.

I've seen examples on formatting text, but not entire rows.

Thanks

Paul
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
1. Select the entire row
2. Choose the Format | Conditional Formatting... menu command
3. Setup a "Formula Is" condition using =$E6="FL" and applying a green cell pattern.
 
Upvote 0
Howdy,

Try the Tip Of The Week on the Mr Excel homepage. Underneath the Gantt part, it shows you what you want to know

Audiojoe
Sometimes I feel like I don't have a partner
 
Upvote 0
On 2002-04-22 07:22, paulrus wrote:
Can anyone give me an example of how to format a ROW based on a formula? For example - if cell E6= "FL" then shade the entire row 6 Green.

1. Highlight row 6
2. Select conditional format from the format menu
3. change drop down to formula.
4. enter formula
=$e$6="fl"
5. Click format box and choose your green

good luck
This message was edited by IML on 2002-04-22 07:31
 
Upvote 0
I'm sorry - my question wasn't specific enough. What I wanted to do was conditionally format it not only based on whether or not E6= "FL", but I want to evaluate all of E:E and format rows based on whether or not the state listed is FL, HI, MS, NJ, and so on. Basically I have a list of states, if E:E = one of the names on that list I want to change the color of the row so it's easy for me to spot those rows.

I'm still learning so forgive me for the newbie questions.
 
Upvote 0
you could name your list "states" via the name box.

following the conditional formmating steps and use the formula
=COUNTIF(states,A6)

in cell a6.

Select a6, use the format painter and then select all of row 6.
 
Upvote 0
Well.. this isn't working, but here's what I was trying:

=COUNTIF(states({"FL", "HI", "MS", "NJ", "SC", "DE", "KY", "LA", "MA", "NM", "PR", "VT", "WA", "WV", "WI"}),4:52)

Basically between rows 4:52 if states is one of those listed I wanted to change the color of the row.

This is a bit frustrating....
 
Upvote 0
On 2002-04-22 08:02, paulrus wrote:
Well.. this isn't working, but here's what I was trying:

=COUNTIF(states({"FL", "HI", "MS", "NJ", "SC", "DE", "KY", "LA", "MA", "NM", "PR", "VT", "WA", "WV", "WI"}),4:52)

Basically between rows 4:52 if states is one of those listed I wanted to change the color of the row.

This is a bit frustrating....

You can't use an array constant for Conditional Formatting or Data Validation. List your states in a cell range, and use...

=COUNTIF(cell_range,$E6)

...where cell_range is the cell range containing your state abbreviations.
This message was edited by Mark W. on 2002-04-22 08:07
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

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
Back
Top