Excel conditional formatting row color

[Closed]
Report
Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
March 26, 2014
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
March 26, 2014

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.
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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