Excel conditional formatting row color
[Closed]
Report
drchetanb
TrowaD
- Posts
- 2
- Registration date
- Tuesday November 12, 2013
- Status
- Member
- Last seen
- March 26, 2014
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
Related:
- Excel conditional formatting row color
- Excel conditional formatting row color ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Excel Conditional Formatting Rows to Columns ✓ - Forum - Excel
- More than 3 conditional formats in Excel ✓ - Forum - Excel
- Conditional Formatting: Font color for entire column based on another column ✓ - Forum - Excel
3 replies
TrowaD
- Posts
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
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
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
- 2818
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 18, 2021
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
