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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 14, 2015 at 09:28 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 14, 2015 at 09:28 PM
Related:
- Conditional formatting help please
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- After formatting computer what's next ✓ - Laptop Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.