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

Hi There.
I've spent about 4 hours trying to work out the formula or what I'm doing wrong to no avail, please help me before I lose my mind.
I need to bold a columnn of out standing fines (need to bold the unpaid monetary value) based on whether they are unpaid in the column next to it which is paid or unpaid.
The amounts start in E2 and the corresponding column of paid or unpaid starts in F2.
I'm at a loss and have spent hours online trying to find a resolution.
I am using Excel 2013
Please help, Thanks

Changing the format of a cell based on another cell with text
Clear only the formatting from the selected cell (leaving the content) - Guide
Based on the values in cells b77 b81 ✓ - Excel Forum
Format factory - Download - Other
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Office Software Forum

1 response

Answer 1 / 1

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

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

Similar discussions

help me to add particular cells

Highlight cell if another cell contains specific text

If a cell contains any text then add a value

Excel function question

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!