Previous Topic Next Topic

Excel conditional formatting row color

Closed
drchetanb
Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
March 26, 2014
 - Nov 12, 2013 at 02:04 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 - Mar 31, 2014 at 10:41 AM
Hello,

I want to change automatically the color of a whole row (from A to H) depending on the entry in column H which contain any "text" (suppose if Alfa then green and if Beta then red)by using conditional format, but unable to do so.

Please guide.

Rgds.

3 replies

Answer 1 / 3
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 514
Nov 12, 2013 at 11:53 AM
Hi Drchetanb,

That depends on your Excel version. Do you use the ribbon style Excel?
If you do then take a look here:
http://www.excel-2010.com/conditional-formatting-in-microsoft-excel-2010/

If not then select column A:H for one row only (in this example A1:H1).
Goto top menu > Format > Conditional Format.
Select "formula is" from the first drop down menu.
Formula: =H1="Alfa" apply green.
New rule
Formula: =H1="Beta" apply red.

Now drag A1:H1 down as far as needed. When done dragging a small square should appear with the option to apply format only.

Best regards,
Trowa
1
Answer 2 / 3
drchetanb
Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
March 26, 2014
Mar 26, 2014 at 10:44 AM
Thanks for the info.

I am using Excel 2007. Tried it, but not working.

I forgot to mention that I have set a formula in column H. Whenever I enter a value in column C or D or E and different text will be populated in column H and for that different text I set different colour. Those color applied to the cell only.

Now, I want, whatever the value populated in column H, the colour applies to entire ROW.

I tried =$H1="TEXT" and applied different color, but doesn't work.

Please guide.

Thanks in advance.
0
Answer 3 / 3
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 514
Mar 31, 2014 at 10:41 AM
Hi Drchetanb,

Strange...

In the following file I have colored H1:H9 orange and put a formula in it.
The formula will put "TEXT" in the cell if column C (same row) has "1" entered in it.
This will change the row color to red.

Check out how CF is applied.

Here is the file:
http://speedy.sh/RKPAU/Drchetanb-Excel-conditional-format.xls

If I misunderstood you, then re-explain with examples.

Best regards,
Trowa
0