Previous Topic Next Topic

Changing the format of a cell based on another cell with text

Closed
Tam4217 Posts 1 Registration date Sunday 1 September 2013 Status Member Last seen 1 September 2013 - 1 Sep 2013 à 11:04
Kevin@Radstock Posts 42 Registration date Thursday 31 January 2013 Status Member Last seen 26 April 2014 - 1 Sep 2013 à 12:06
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

1 response

Réponse 1 / 1
Kevin@Radstock Posts 42 Registration date Thursday 31 January 2013 Status Member Last seen 26 April 2014 9
1 Sep 2013 à 12:06
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
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses