Apply conditional formatting to individual cell Excel 2007

J

James D

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?
 
R

Roger Govier

Hi James

Select a single cell>Home tab>Conditional Formatting>New rule>last
item>Use a formula
=A1>20 for example
 
J

James D

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
 
T

T. Valko

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
Click to expand...

Biff
 
Top