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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 31, 2014 at 10:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 31, 2014 at 10:41 AM
Related:
- Excel conditional formatting row color
- Excel date format dd.mm.yyyy - Guide
- Saints row 2 cheats - Guide
- Marksheet format in excel - Guide
- Notepad++ background color - Guide
- Clear formatting in excel - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 12, 2013 at 11:53 AM
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
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
Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
March 26, 2014
Mar 26, 2014 at 10:44 AM
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.
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
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 31, 2014 at 10:41 AM
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
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
