Changing the format of a cell based on another cell with text
Closed
Tam4217
Posts
1
Registration date
Sunday September 1, 2013
Status
Member
Last seen
September 1, 2013
-
Sep 1, 2013 at 11:04 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Sep 1, 2013 at 12:06 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Sep 1, 2013 at 12:06 PM
Related:
- Changing the format of a cell based on another cell with text
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Format factory - Download - Other
- Count if cell contains number - Excel Forum
- How to change date format in excel - Guide
1 response
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Sep 1, 2013 at 12:06 PM
Sep 1, 2013 at 12:06 PM
Hi
Select the values in column E, ie: E2:E50. Then on the home tab > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Then in the Format values where this formula is true: enter the following formula:=$F2="Unpaid". Format the font bold.
Kevin
Select the values in column E, ie: E2:E50. Then on the home tab > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Then in the Format values where this formula is true: enter the following formula:=$F2="Unpaid". Format the font bold.
Kevin