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
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel date format dd.mm.yyyy - Guide
How to change account based in instagram - Instagram Forum
If cell contains text then return value in another cell ✓ - Excel Forum
If a cell contains any text then add a value ✓ - Excel 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

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains any text

help me to add particular cells

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!