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
- Based on the values in cells b77 b88 - Excel Forum
- Excel add 1 if cell contains text ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- Clear only the formatting from the selected cell - Guide
- Cell phone codes - 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