Excel 2007 : Highlighting Multiple Cell Values in Same Row If .....

I think i misinterpreted what I wanted. I meant to say if cell A1 contains the letter "S", then fill the cells A5:F5 with red color.

not sure why you would want an if formula but you can use

$A$1="S"

Originally Posted by grizzly6969

not sure why you would want an if formula but you can use

I placed that formula in the formula bar but it came out as text. Also, where do i go about enabling the highlight function?

what version of excel are you using

OK if you are using excel 2007 open the file I have attatched

Highlight A1:F1 go to conditional format / new rule / use a formula to determine which cells to format
put in formula

=$A1="S"

and format your colour and OK
now left click and highlight A1:F1 and right click and go COPY drag down as far as you need then right click and go to PASTE SPECIAL then click on FORMATS and click ok
this will do what you want

Thank you!

glad I could help

Btw, is there a way to tell Excel to change the font color if a cell has a value greater than 0?

I tried using the IF formula but am stuck at how to tell it to change font color if true.

Ex: If A1>0, change font color to red, if false, input "X".

Originally Posted by grizzly6969

Highlight A1:F1 go to conditional format / new rule / use a formula to determine which cells to format
put in formula and format your colour and OK
now left click and highlight A1:F1 and right click and go COPY drag down as far as you need then right click and go to PASTE SPECIAL then click on FORMATS and click ok
this will do what you want

Hi grizzly6969. I am actually having the same issue as boba7523. Mine though is that I having trouble copying the conditional format I made to the succeeding cells/rows.

Anyway, what I wanted was that if cell J3 contains the word PENDING, cells B3 to J3 will be highlighted in red. I was able to do it by making a rule on conditional format using formula =COUNTIF($B$3:$J$3,"PENDING")
What I'm having trouble with is copying the conditional format rule I made to the succeeding rows.

I am using Excel 2007 and my worksheet contains 200 rows. I would appreciate if you can teach me duplicating such rule so that I don't have to repeat the same process for the succeeding rows.

Hello Saishu, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.