Excel conditional formatting row color
Closed
drchetanb
TrowaD
- Posts
- 2
- Registration date
- Tuesday November 12, 2013
- Status
- Member
- Last seen
- March 26, 2014
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
- Excel conditional formatting 3 color scale formula ✓ - Forum - Excel
- More than 3 conditional formats in Excel ✓ - Forum - Excel
3 replies
TrowaD
Nov 12, 2013 at 11:53 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
Mar 26, 2014 at 10:44 AM
- 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.
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
Mar 31, 2014 at 10:41 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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