Conditional format based on another cell containing text
Closed
stakik
-
Mar 5, 2015 at 03:21 AM
Corrina66 Posts 1 Registration date Sunday January 8, 2017 Status Member Last seen January 8, 2017 - Jan 8, 2017 at 06:49 PM
Corrina66 Posts 1 Registration date Sunday January 8, 2017 Status Member Last seen January 8, 2017 - Jan 8, 2017 at 06:49 PM
Related:
- If cell contains text then
- Highlight cell if another cell contains text - Best answers
- Conditional formatting excel if another cell contains specific text - Best answers
- Conditional formatting if cell contains text - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Mar 5, 2015 at 09:10 PM
Mar 5, 2015 at 09:10 PM
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...
Mar 5, 2015 at 09:10 PM
https://www.dropbox.com/s/79ip1uo9zj4ji3h/Format%20Reservation.xlsx?dl=0
Jan 8, 2017 at 06:49 PM
I can't seem to access the dropbox. Are you able to resend or copy the formula here?
Many thanks,
Corrina
Mar 6, 2015 at 03:20 AM
i will fix it now that you show me the way .it must be the ''.
thanks again
Mar 7, 2015 at 11:00 AM
Enjoy.