Conditional formatting excel 2003
 

I need to accomplish several tasks and I am stuck. I am limited to 3
formats so I will list them in order of Importance I know how to do
2,3,4 so if you can tell me how to do #1, I can skip #4 and get this
done.

1. If a row has anything in the first cell, format all the cells in
that row that have anything in them to a pink fill, otherwise leave
them white (no fill)
If I use .......=$A1"" that will change the entire row 1 to the fill
color that I choose (pink), if there is data in A1. But I only want
B1, F1, and G1 to fill color pink since they have data in them. The
rest are blank. Row 2 will certainly have different cells that have
data.

2. If a cell anywhere has APL it should be red text, yellow fill

3. If a cell anywhere has Holiday in it it should be red text green
fill.

4. If a cell anywhere has HW in it, I want the fill color to be blue.

Conditional formatting excel 2003
 

.. so if you can tell me how to do #1, ...

Select entire sheet (A1 active),
& try applying this as your CF condition 1:
=AND($A1<"",A1<"")
Format: Pink fill
(Default normal fill for the sheet is assumed set to: No fill)

The above should trigger it as desired
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
I need to accomplish several tasks and I am stuck. I am limited to 3
formats so I will list them in order of Importance I know how to do
2,3,4 so if you can tell me how to do #1, I can skip #4 and get this
done.

1. If a row has anything in the first cell, format all the cells in
that row that have anything in them to a pink fill, otherwise leave
them white (no fill)
If I use .......=$A1"" that will change the entire row 1 to the fill
color that I choose (pink), if there is data in A1. But I only want
B1, F1, and G1 to fill color pink since they have data in them. The
rest are blank. Row 2 will certainly have different cells that have
data.

2. If a cell anywhere has APL it should be red text, yellow fill

3. If a cell anywhere has Holiday in it it should be red text green
fill.

4. If a cell anywhere has HW in it, I want the fill color to be blue.