Conditional formatting help please
Closed
lb_028
Posts
1
Registration date
Friday February 13, 2015
Status
Member
Last seen
February 13, 2015
-
Feb 13, 2015 at 02:05 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Feb 14, 2015 at 09:28 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Feb 14, 2015 at 09:28 PM
Related:
- Conditional formatting help please
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Copy conditional formatting but change reference cell ✓ - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Feb 14, 2015 at 09:28 PM
Feb 14, 2015 at 09:28 PM
Hello lb_028,
Perhaps this may help:-
- Highlight cells N19:N30
- Go to Conditional Formatting in the Home tab
- Click on New Rule.
- Select "Use a formula to determine which cells to format"
- Type in the following rule:-
=H19>=1
- Format to yellow fill.
Test it by entering the numbers you want in H19:H30.
Enter a zero in any of the range cells to test if the yellow fill returns to white.
Expand the range to suit when you first highlight the cells.
I hope this helps.
Regards,
vcoolio.
Perhaps this may help:-
- Highlight cells N19:N30
- Go to Conditional Formatting in the Home tab
- Click on New Rule.
- Select "Use a formula to determine which cells to format"
- Type in the following rule:-
=H19>=1
- Format to yellow fill.
Test it by entering the numbers you want in H19:H30.
Enter a zero in any of the range cells to test if the yellow fill returns to white.
Expand the range to suit when you first highlight the cells.
I hope this helps.
Regards,
vcoolio.