Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
excel 2007 conditional formating
frankenstein
Posts: 13 Forumite
in Techie Stuff
If I have a column in excel 2007, column C, where some of the cells contain the word mortgage, how can I get the equivalent cell in column E to have a red background?
C2 contains mortgage E2 has a red background
C10 contains mortgage E10 has a red background
and so on
Frank.
C2 contains mortgage E2 has a red background
C10 contains mortgage E10 has a red background
and so on
Frank.
0
Comments
-
Select the range of cells where you want the formatting to appear (e.g. E2:E10)
Go to Home tab > Conditional Formatting > New Rule...
Select Use a formula to determine which cells to format
In the formula box type =IF(C2="mortgage",1,0)
Click the Format... button and select your preferred fill colour
Click OK etc
HTH0 -
Select the range you want the conditional formatting to cover e.g. E2:E20. Create a new rule in Conditional Formatting and select 'Use a formula to determine which cells to format'. In the formula box enter =$C2="mortgage" then click format to select how you want the cell to look then ok. If mortgage isn't the only word in C2 then you can use =MATCH("*mortgage*",$C2,0). The wildcards means any variation of mortgage will be highlighted e.g. mortgages, full mortgage etc0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards