Conditional Formatting Columns
Closed
vschu
Posts
1
Registration date
Thursday November 15, 2018
Status
Member
Last seen
November 15, 2018
-
Nov 15, 2018 at 09:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 15, 2018 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 15, 2018 at 11:25 AM
Related:
- Conditional Formatting Columns
- Excel formula to change cell color without conditional formatting - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - 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
- How to clear formatting in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Nov 15, 2018 at 11:25 AM
Nov 15, 2018 at 11:25 AM
Hi Vschu,
Select column C, goto conditional formatting and choose new rule.
Select the second option: Format only cell that contain.
1st dropdown: Cell value
2nd dropdown: Greater then
3rd field: B1
Choose format
Click OK
No need to drag it down.
Best regards,
Trowa
Select column C, goto conditional formatting and choose new rule.
Select the second option: Format only cell that contain.
1st dropdown: Cell value
2nd dropdown: Greater then
3rd field: B1
Choose format
Click OK
No need to drag it down.
Best regards,
Trowa