Conditional format based on another cell containing text
Closed
stakik
-
5 Mar 2015 à 03:21
Corrina66 Posts 1 Registration date Sunday 8 January 2017 Status Member Last seen 8 January 2017 - 8 Jan 2017 à 18:49
Corrina66 Posts 1 Registration date Sunday 8 January 2017 Status Member Last seen 8 January 2017 - 8 Jan 2017 à 18:49
Related:
- Highlight cell if another cell contains text
- Conditional formatting excel if another cell contains specific text - Best answers
- If cell contains specific text highlight another cell - Best answers
- Excel add 1 if cell contains text ✓ - Excel Forum
- If i highlight a close friend story - Instagram Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Help me to add particular cells ✓ - Excel Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
5 Mar 2015 à 21:10
5 Mar 2015 à 21:10
Hello Stavros,
Here's a possibility for you. The spreadsheet at the DropBox link below will format the cell value as red and will show another cell with a negative number. I'm thinking this does most of what your want but doesn't overwrite the value of the original booking.
It's a matter of
1. Using conditional formatting based on the contents of the adjacent cell and
2. Using an "If" statement to multiply the cell contents by -1 and entering that result into another cell based on the same cell's content.
Hope that give you an idea where to go with it...
Here's a possibility for you. The spreadsheet at the DropBox link below will format the cell value as red and will show another cell with a negative number. I'm thinking this does most of what your want but doesn't overwrite the value of the original booking.
It's a matter of
1. Using conditional formatting based on the contents of the adjacent cell and
2. Using an "If" statement to multiply the cell contents by -1 and entering that result into another cell based on the same cell's content.
Hope that give you an idea where to go with it...
5 Mar 2015 à 21:10
https://www.dropbox.com/s/79ip1uo9zj4ji3h/Format%20Reservation.xlsx?dl=0
8 Jan 2017 à 18:49
I can't seem to access the dropbox. Are you able to resend or copy the formula here?
Many thanks,
Corrina
6 Mar 2015 à 03:20
i will fix it now that you show me the way .it must be the ''.
thanks again
7 Mar 2015 à 11:00
Enjoy.