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 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
- Based on the values in cells b77 b88 - Excel Forum
- Based on the cell values in cells b77 - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Conditional formatting based on another cell text - Excel Forum
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
