Excel conditional formatting row color Closed

Question

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.

TrowaD · Answer

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

drchetanb · Answer

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.

TrowaD · Answer

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

Excel conditional formatting row color

3 responses

Similar discussions

Subscribe To Our Newsletter!