Wow, I just be brain dead. In Excel 2003, I could choose individual
conditional formatting for one cell. In Excel 2007, it seems I have to choose
rules for the entire sheet....I don't want to do that. I just want to apply
a conditional format to one individual cell. How can I accomplish that?

--
Thank you all for your help!

Hi James

Select a single cellHome tabConditional FormattingNew rulelast
itemUse a formula
=A120 for example

--
Regards

Roger Govier


"James D" wrote in message
...
Wow, I just be brain dead. In Excel 2003, I could choose individual
conditional formatting for one cell. In Excel 2007, it seems I have to
choose
rules for the entire sheet....I don't want to do that. I just want to
apply
a conditional format to one individual cell. How can I accomplish
that?

--
Thank you all for your help!

Roger, thanks for the quick response.
I tried what you said, but once I choose New Rule, I don't get an option for
"last item" I get:
Format all cells based on there value
Format only cells that contain
Format only top or bottom ranked values
Format only values that are above or below average
Fromat only unique or duplicate values
Use formula to detemine which cells to format

I cannot find the "last item" you are referring to. Based on the options I
copied above, did I go to the wrong place? I chose the cell, chose the
conditional formatting icon, chose New Rules...and that's were we diverge.....

thanks for looking at this again,

James

--
Thank you all for your help!


"James D" wrote:

Wow, I just be brain dead. In Excel 2003, I could choose individual
conditional formatting for one cell. In Excel 2007, it seems I have to choose
rules for the entire sheet....I don't want to do that. I just want to apply
a conditional format to one individual cell. How can I accomplish that?

--
Thank you all for your help!

I think what Roger meant by "last item" is use the last item from the list
of options which would be:

Use formula to detemine which cells to format

Biff

"James D" wrote in message
...
Roger, thanks for the quick response.
I tried what you said, but once I choose New Rule, I don't get an option
for
"last item" I get:
Format all cells based on there value
Format only cells that contain
Format only top or bottom ranked values
Format only values that are above or below average
Fromat only unique or duplicate values
Use formula to detemine which cells to format

I cannot find the "last item" you are referring to. Based on the options I
copied above, did I go to the wrong place? I chose the cell, chose the
conditional formatting icon, chose New Rules...and that's were we
diverge.....

thanks for looking at this again,

James

--
Thank you all for your help!


"James D" wrote:

Wow, I just be brain dead. In Excel 2003, I could choose individual
conditional formatting for one cell. In Excel 2007, it seems I have to
choose
rules for the entire sheet....I don't want to do that. I just want to
apply
a conditional format to one individual cell. How can I accomplish that?

--
Thank you all for your help!