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
If cell contains text then return value multiple conditions ✓ - Excel Forum
How to change account based in instagram - Instagram Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
If cell contains date then return value ✓ - Office Software Forum
Excel date format dd.mm.yyyy - Guide

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

How to use conditional format based on text?

Highlight cell if another cell contains specific text

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!