I have data on rows 1 thru 10,
In column C the data is either "pending" or something else
I clicked the mouse on the 1 for the row header for row 1 and dragged down
to row 10; the first 10 rows are selected
I used Format | Conditional Format in Excel 2003
In Excel 2007 open the Home tab and locate the Styles group and click on
Conditional Formatting | New Rule
Is used Formula Is: =$C1="pending" and clicked the Format button to give
that row a yellow pattern and italic font
The I added another Formula Is: =$C1<"pending" and clicked the Format
button and make the pattern blue with bod font
A test shows this method worked as expected
See also Debra Dalgleish At:
http://www.contextures.com/xlCondFormat01.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Gail" wrote in message
...
I have no idea how to highlight a whole row when I have a set condition.
You see, I need to shade a row of data (8-rows of content), yellow when it
is pending, and I need to turn those rows yellow/italic when the they are
NOT
approved, and I have to get those same rows to turn black and Bold when
they
ARE approved. How on earth can I get the conditional formating to do
that,
and can you dumb it down completely, as I have no clue how to build out
formulas at all.
My data is for what program content has rights -- so I have a wide list of
shows, producers, distributors, etc. All the legal reps will do is
indicate
"Y" "N" or "P" in the cell, and then carry on down to the next cell.
There
could be hundreds of rows of content... is this even possible???
help please -- I can be reached at or at
"SteveG" wrote:
Christine,
Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter
=B1="Your Text"
Click Format, Font select the color you want. Click OK, OK.
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036