View Single Post
  #14  
Old June 6th, 2010, 07:21 AM posted to microsoft.public.excel.newusers
VENUS
external usenet poster
 
Posts: 20
Default fill a color to a row

Howard,
Thank you - thank you. I had spent hours agonizing over what I did wrong;
your solution worked. I appreciate your help
Thanks,
Venus

"L. Howard Kittle" wrote:

For A1:A20 try this...

Select the range and in the formula is box enter =A1=25

HTH
Regards,
Howard

"Venus" wrote in message
...
I have a different problem. When I select a column and click the
Conditional
Formatting command from the home tab in Excel 2007, my formula will not
work.
I have a column of numbers ranging from 15 to 35. I inputted the formula
=$A$1:$A$20=25 to format all cells in column A having a value of 25 or
higher. I'm not sure what I am doing wrong, but it isn't working. My
Excel
Option (Formula Tab - Calculations is also set at Automatic.) Can someone
help me
Venus

"mns" wrote:

Hi,
I want to check a column (lets say H) if there is a 1 value i want excel
to
color the row.

lets say there is a 1 on H6, I want to fill a color to row 6. It can be
full
coloring or if i can i might like to range it to A6:J6

thanx in advance



.