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.
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....