Conditional formatting help please
Closed
lb_028
Posts
1
Registration date
Friday 13 February 2015
Status
Member
Last seen
13 February 2015
-
13 Feb 2015 à 02:05
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 14 Feb 2015 à 21:28
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 14 Feb 2015 à 21:28
Related:
- Conditional formatting help please
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Risk formatting excel - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Conditional formatting between two values ✓ - Excel Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
14 Feb 2015 à 21:28
14 Feb 2015 à 21:28
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.

